| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PNLGRPNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Component Name
|
| 2 |
PNLNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Page Name (see PSPNLDEFN).
|
| 3 |
OCCURSLEVEL_1 |
Signed Number(2,0) |
DECIMAL(1) NOT NULL |
Used in ERD_REL.sqr for extracting Table Relationships in PeopleSoft DB.
|
| 4 |
OCCURSLEVEL_2 |
Signed Number(2,0) |
DECIMAL(1) NOT NULL |
Used in ERD_REL.sqr for extracting Table Relationships in PeopleSoft DB.
|
| 5 |
REC_PARENT |
Character(18) |
VARCHAR2(18) NOT NULL |
Field used in Record EO_ERD_REL for ERD_REL.sqr, an SQR Process to extract Table Relationships in PeopleSoft. This Field is used to store "Parent Record" Name of a given record in PeopleSoft.
|
| 6 |
REC_CHILD |
Character(18) |
VARCHAR2(18) NOT NULL |
Field used in Record EO_ERD_REL for ERD_REL.sqr, an SQR Process to extract Table Relationships in PeopleSoft. This Field is used to store "Child Record" Name of a given parent/child records pair in PeopleSoft.
|
| 7 |
KEYNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Key Name
|
| 8 |
KEY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Key Field
|
| 9 |
KEYPOSN |
Number(3,0) |
SMALLINT NOT NULL |
Key Position
|
| 10 |
OBJECTOWNERID |
Character(4) |
VARCHAR2(4) NOT NULL |
Object owner identifier
|