EMPLIDEFFDTDefault Value: %date
GVT_CAR_DEV_ELIGA=Administrative Intern Program
C=Career Program
E=Career Enhancement Program
N=None
P=Computer Programmer Trainee
W=WAO Intern Program
Y/N Table Edit
HR_CPGVTDVEL_VW(SQL View) |
Index Back |
|---|---|
CP IDP Career Dev EligilbilityData used for Career Planning Individual Development Plan report. |
| SELECT EMPLID , EFFDT , GVT_CAR_DEV_ELIG , ' ' , GVT_CAR_DEV_PART , ' ' FROM PS_GVT_CAR_DEV_ELG |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | GVT_CAR_DEV_ELIG |
Character(1) | VARCHAR2(1) NOT NULL |
Developmental Program
A=Administrative Intern Program C=Career Program E=Career Enhancement Program N=None P=Computer Programmer Trainee W=WAO Intern Program |
| 4 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |
| 5 | GVT_CAR_DEV_PART | Character(1) | VARCHAR2(1) NOT NULL |
Currently Participating
Y/N Table Edit |
| 6 | PARTICIPANT | Character(20) | VARCHAR2(20) NOT NULL | Participant ID |