FIELDNAMEHRS_POS_FLD_VW(SQL View) |
Index Back |
|---|---|
POSITION_DATA Fields |
| SELECT DISTINCT FIELDNAME FROM PSRECFIELD WHERE RECNAME IN ('HRS_POSN_DTA_I2') AND FIELDNAME IN ('BUSINESS_UNIT', 'CLASS_INDC', 'COMPANY', 'CONFIDENTIAL_POSN', 'DEPTID', 'EFF_STATUS', 'EFFDT', 'FTE', 'JOB_SHARE', 'JOBCODE', 'KEY_POSITION', 'LOCATION', 'ORGCODE', 'ORGCODE_FLAG', 'POSITION_NBR', 'POSITION_POOL_ID', 'POSN_STATUS', 'REG_REGION', 'REG_TEMP', 'SHIFT', 'UNION_CD') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |