BUSINESS_UNIT_BDPOSITION_NBRDefault Value: 0
EMPLIDEMPL_RCDEFFDTDefault Value: %date
BD_POS_POOL_WRK(SQL Table) |
Index Back |
|---|---|
Position DataPOSITION_DATA is the main data record for the Position Management application. It is also used in Succession Planning to establish key positions. If Position Management is installed, data contained in LIKE field names is copied across to the Job record as Position Data changes. /* PLEASE NOTE: The PeopleCode currently on REG_REGION.SaveEdit MUST be located on the last data field on the record. If you modify Position Management, new fields must be added above this logic, or the logic moved accordingly.*/ |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_BD |
Character(5) | VARCHAR2(5) NOT NULL | Budgeting Business Unit |
| 2 | POSITION_NBR |
Character(8) | VARCHAR2(8) NOT NULL |
Position Number
Default Value: 0 |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 5 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 6 | POSITION_POOL_ID | Character(3) | VARCHAR2(3) NOT NULL | Position Pool ID |
| 7 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department Set ID |
| 8 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 9 | FTE | Number(8,6) | DECIMAL(7,6) NOT NULL | This field represent Full Time Equivalence |