PTLT_COMP_R_STG(SQL Table) |
Index Back |
---|
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
2 | Character(30) | VARCHAR2(30) NOT NULL | Task Code | |
3 | Character(30) | VARCHAR2(30) NOT NULL | Page Name (see PSPNLDEFN). | |
4 | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). | |
5 | Character(18) | VARCHAR2(18) NOT NULL | SubPanel Name | |
6 | Number(1,0) | SMALLINT NOT NULL | Occurs level | |
7 | 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 |
8 | ACTIONS | Number(4,0) | SMALLINT NOT NULL | Actions |
9 | ADDSRCHRECNAME | Character(15) | VARCHAR2(15) NOT NULL | Additional Search Record Name |
10 | SEARCHRECNAME | Character(15) | VARCHAR2(15) NOT NULL | Search Record Name |