POSITION_NBRDefault Value: 0
EFFDTDefault Value: %date
Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT
Prompt Table: BUS_UNIT_TBL_HR
Prompt Table: DEPT_TBL
Prompt Table: JOBCODE_TBL
A=Approved
P=Proposed
R=Frozen
Default Value: A
POSITION_VW2(SQL View) |
Index Back |
|---|---|
Position_VW2POSITION_VW2 is a view of the Position Data record, which screens out most PeopleCode. It is used to bring in the Business Unit, Deptid, Jobcode, and Position Status information and location for the most effective-dated row. Used on Succession Planning / Talent Pool Processing feature |
| SELECT POSITION_NBR , EFFDT , DESCR , DESCRSHORT , BUSINESS_UNIT , DEPTID , JOBCODE , POSN_STATUS , LOCATION 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: 0 |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT Prompt Table: BUS_UNIT_TBL_HR |
| 6 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 7 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL |
Job Code
Prompt Table: JOBCODE_TBL |
| 8 | POSN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Position Status
A=Approved P=Proposed R=Frozen Default Value: A |
| 9 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |