REC_PARENTREC_CHILDKEYNAMEEO_ERD_TBL_VW(SQL View) |
Index Back |
|---|---|
PSFT Table Relationships ViewUsed to extract PeopleSoft Table Relationships data for third party CASE Tools Vendor Applications |
| SELECT DISTINCT REC_PARENT , REC_CHILD , KEYNAME , KEY_FLG , KEYPOSN FROM PS_EO_ERD_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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. |
| 2 | 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. |
| 3 | KEYNAME |
Character(18) | VARCHAR2(18) NOT NULL | Key Name |
| 4 | KEY_FLG | Character(1) | VARCHAR2(1) NOT NULL | Key Flag |
| 5 | KEYPOSN | Number(3,0) | SMALLINT NOT NULL | Key Position |