HRS_POSN_DTA_I2(SQL View) |
Index Back |
|---|---|
Position DataHRS_POSN_DTA_I2 is an interface view for the POSITION_DATA HR table. Thie view is created for use only by ERP |
| SELECT POSITION_NBR , EFFDT , CLASS_INDC , COMPANY , CONFIDENTIAL_POSN , FTE , JOB_SHARE , KEY_POSITION , LOCATION , ORGCODE , ORGCODE_FLAG , POSITION_POOL_ID , REG_REGION , REG_TEMP , SHIFT , UNION_CD , EFF_STATUS , DESCR , DESCRSHORT , GVT_ORG_TTL_DESCR , BUSINESS_UNIT , DEPTID , JOBCODE , POSN_STATUS FROM PS_POSITION_DATA |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  POSITION_NBR |
Character(8) | VARCHAR2(8) NOT NULL |
Position Number
Default Value: 00000000 |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | CLASS_INDC | Character(1) | VARCHAR2(1) NOT NULL |
Classified/Unclassified Indc
B=All C=Classified T=Temporary U=Unclassified |
| 4 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 5 | CONFIDENTIAL_POSN | Character(1) | VARCHAR2(1) NOT NULL | Confidential Position |
| 6 | FTE | Number(8,6) | DECIMAL(7,6) NOT NULL | This field represent Full Time Equivalence |
| 7 | JOB_SHARE | Character(1) | VARCHAR2(1) NOT NULL | Job Sharing Permitted |
| 8 | KEY_POSITION | Character(1) | VARCHAR2(1) NOT NULL | Key Position |
| 9 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 10 | ORGCODE | Character(60) | VARCHAR2(60) NOT NULL | Organization Hierarchy Code |
| 11 | ORGCODE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Organization Hierarchy Flag |
| 12 | POSITION_POOL_ID | Character(3) | VARCHAR2(3) NOT NULL | Position Pool ID |
| 13 | REG_REGION | Character(5) | VARCHAR2(5) NOT NULL | Regulatory Region |
| 14 | REG_TEMP | Character(1) | VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular T=Temporary |
| 15 | SHIFT | Character(1) | VARCHAR2(1) NOT NULL |
Regular Shift
1=1 2=2 3=3 A=Any C=Compressed N=Not Applicable R=Rotating |
| 16 | UNION_CD | Character(3) | VARCHAR2(3) NOT NULL | Union Code |
| 17 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 18 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 19 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 20 | GVT_ORG_TTL_DESCR | Character(70) | VARCHAR2(70) NOT NULL | Organization Position Title |
| 21 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT Prompt Table: BUSUNIT_HR_VW |
| 22 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 23 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL |
Job Code
Prompt Table: %RECNAME_EDIT |
| 24 | POSN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Position Status
A=Approved P=Proposed R=Frozen Default Value: A |