PTRECDEFN

index back

PeopleSoft Field Name Field Type Column Type Description
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
RECTYPE Number(1,0) SMALLINT NOT NULL Record Type
0=SQL Table
1=SQL View
2=Derived Work/Record
3=Subrecord
5=Dynamic View
6=Query View
7=Temporary Table
SQLTABLENAME Character(18) VARCHAR2(18) NOT NULL SQL Table Name
SYSTEMIDFIELDNAME Character(18) VARCHAR2(18) NOT NULL System ID Field Name
TIMESTAMPFIELDNAME Character(18) VARCHAR2(18) NOT NULL Row Level TimeStamp Field Name
OPTTRIGFLAG Character(1) VARCHAR2(1) NOT NULL Optimization Triggers?
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20