GPGB_SET_EVNTL1(SQL Table) |
Index Back |
---|---|
Employee Pension DetailsLevel 1 pension applicant status table for Pension GBR |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GPGB_PEN_EVENT | Character(20) | VARCHAR2(20) NOT NULL | Pension Events GBR |
2 | GPGB_PEN_A_STATUS | Character(50) | VARCHAR2(50) NOT NULL | Pension Applicant Status GBR |
3 | GPGB_PENSTAT_ID | Character(10) | VARCHAR2(10) NOT NULL | Pension Applicant Status ID GBR |
4 | GPGB_PRC_USED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Process Used Flag for GBR
0=NO 1=YES |
5 | GPGB_PEN_SRSN_DESC | Long Character | CLOB | Pension Applicant Status Reason Description GBR |
6 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type Code
N=Customer Data S=Sample Data Y=System Data Default Value: N |