GPGB_QPN_DFLTL1(SQL Table) |
Index Back |
---|---|
Pension Scheme Defaults GBRQualifying Pension Scheme Defaults GBR |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
2 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
3 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
4 | GPGB_QPEN_SCHEME | Character(10) | VARCHAR2(10) NOT NULL |
Pension Scheme for GBR
Prompt Table: GPGB_QPEN_VW |
5 | GPGB_QE_PIN_CODE | Character(22) | VARCHAR2(22) NOT NULL |
Qualifying Earning Accumulator GBR
Prompt Table: GPGB_ACM_VW |
6 | GPGB_POSTPONE_WR | Number(3,0) | SMALLINT NOT NULL | Worker Postponement for GBR |
7 | GPGB_POSTPONE_JD | Number(3,0) | SMALLINT NOT NULL | Job Holder Postponement for GBR |