HRS_JO_ENCUMB_I(SQL View) |
Index Back |
|---|---|
Interface view for encumbranceView of job requisitions for encumbrance processing |
| SELECT %Substring(%NUMTOCHAR(A.HRS_JOB_OPENING_ID), 1, 6) , A.HRS_PRM_JOBCODE , A.DEPTID , A.AUTHORIZATION_DT , A.PROJECTED_FILL_DT , A.ENCUMB_DT_INDC , A.BUSINESS_UNIT , A.HRS_PRM_POSITION , A.STATUS_CODE FROM PS_HRS_JOB_OPENING A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | JOB_REQ_NBR | Character(6) | VARCHAR2(6) NOT NULL | Job requisition number |
| 2 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 3 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 4 | AUTHORIZATION_DT | Date(10) | DATE | Date Authorized |
| 5 | PROJECTED_FILL_DT | Date(10) | DATE | Projected Fill Date |
| 6 | ENCUMB_DT_INDC | Character(1) | VARCHAR2(1) NOT NULL |
Encumbrance Date Indicator
A=Authorization Date P=Project Fill Date |
| 7 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 8 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 9 | STATUS_CODE | Character(3) | VARCHAR2(3) NOT NULL | Identifies a status. |