RSF_CRIT_REC_VW(SQL View) |
Index Back |
---|---|
Component Records - PrimaryView of all Component Primary Records |
SELECT C.RECNAME , C.RECDESCR FROM PSRECDEFN C WHERE C.RECTYPE IN (0,1) AND C.RECDESCR <> ' ' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | CRITERIA_RECORD | Character(18) | VARCHAR2(18) NOT NULL | Criteria Record for Configurable Assignment |
2 | RECDESCR | Character(30) | VARCHAR2(30) NOT NULL | Record Description |