HR_SPHDR_LNG_VW(SQL View) |
Index Back |
---|---|
SP Header, No Pcode ViewThis view is based on HR_SUCC_PLN_LNG. It selects directly from the table with no joins and no PeopleCode. HR_SUCC_PLN_LNG is the related language header record which contains the effective date of the Succession Plan for this position. There would be one record for each effective-dated plan. |
SELECT HR_SUCC_PLAN_ID , HR_SUCC_PLAN_TYPE , HR_SUCC_PLAN_CTL , EFFDT , LANGUAGE_CD , DESCR FROM PS_HR_SUCC_PLN_LNG |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | HR_SUCC_PLAN_ID | Character(11) | VARCHAR2(11) NOT NULL |
Succession Plan ID
Default Value: NEW |
2 | HR_SUCC_PLAN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Succession Plan Type
1=Job Code 2=Person 3=Position |
3 | HR_SUCC_PLAN_CTL | Character(11) | VARCHAR2(11) NOT NULL |
Succession Plan Control Value
Prompt Table: %EDITTABLE |
4 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
5 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |