EO_RECFIELD5_VW(SQL View) |
Index Back |
---|---|
List of All FieldsResolves fields on subrecords Used for Subselect Record Name |
Select A.RECNAME SBSEL_RECNAME ,B.FIELDNAME SBSEL_FLDNAME From PSRECFIELD A ,PSRECFIELD B Where A.RECNAME = B.RECNAME And A.FIELDNUM = B.FIELDNUM And A.SUBRECORD = 'N' Or A.SUBRECORD = 'Y' And A.FIELDNAME = B.RECNAME |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SBSEL_RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Subselect Record Name |
2 | SBSEL_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL | Subselect Field Name |