HCSC_RTG_FLD2VW(SQL View) |
Index Back |
---|---|
Fieldnames for Set ControlUse this view to define the fieldname for the set control fieldname. |
SELECT RF.RECNAME , RF.FIELDNAME FROM PSRECFIELD RF WHERE RF.FIELDNAME <> 'HCSC_RTG_XREFSB' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | HCSC_RTG_REC_XREF | Character(15) | VARCHAR2(15) NOT NULL | Cross Reference Table |
2 | HCSC_RTG_SET_CNTRL | Character(18) | VARCHAR2(18) NOT NULL | Set Control Field |