RB_CLARECFLD_VW(SQL View) |
Index Back |
---|---|
All record fields w/ subrecThis view brings up all the fields for a record, including the fields in the subrecords, if any. |
SELECT RECNAME ,FIELDNAME FROM PSRECFIELDALL |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(15) | VARCHAR2(15) NOT NULL | Base record that enabled for the supplemental data. | |
2 | Character(18) | VARCHAR2(18) NOT NULL | Record Field Name |