POSITION_NBRDefault Value: 00000000
LANGUAGE_CDEFFDTDefault Value: %date
HR_CP_POSN_LNG(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 ADDS_TO_FTE.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 | POSITION_NBR |
Character(8) | VARCHAR2(8) NOT NULL |
Position Number
Default Value: 00000000 |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |