FIELDNAMEHRS_JOB_FLD_VW(SQL View) |
Index Back |
|---|---|
JOB Fields |
| SELECT DISTINCT FIELDNAME FROM PSRECFIELD WHERE RECNAME IN ('JOB','JOB_ESP_SBR') AND FIELDNAME IN ('ACTION', 'ACTION_REASON', 'BAS_GROUP_ID', 'BEN_STATUS', 'BUSINESS_UNIT', 'COMPANY', 'DEPTID', 'EMPL_STATUS', 'EMPL_TYPE', 'EMPL_CLASS', 'FTE','FULL_PART_TIME', 'GRADE', 'JOBCODE', 'JOB_INDICATOR', 'LOCATION', 'PAYGROUP', 'POSITION_NBR', 'REG_TEMP', 'REG_REGION', 'STD_HOURS') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |