HRS_EMP_FLD_VW(SQL View) |
Index Back |
---|---|
EMPLOYMENT Fields |
SELECT FIELDNAME FROM PSRECFIELD WHERE RECNAME = 'HRS_EMPLOYMT_I' AND FIELDNAME IN ('HIRE_DT','LAST_DATE_WORKED','REHIRE_DT','TERMINATION_DT') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |