GPFR_TERM_GROUP_IDGP_PAYGROUPCAL_PRD_IDCOUNTRYGPFR_TER_OFFCYC_GP0=Create New Group
1=Attach to an Existing Group
2=Attach to a Group later
Default Value: 0
Y/N Table Edit
GPFR_OFFCYC_GP(SQL Table) |
Index Back |
|---|---|
Off Cycle Calendar GroupTo Store the Calendar Group ID created |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPFR_TERM_GROUP_ID |
Character(15) | VARCHAR2(15) NOT NULL | Termination Group ID |
| 2 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 3 | CAL_PRD_ID |
Character(10) | VARCHAR2(10) NOT NULL | Calendar Period ID |
| 4 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 5 | GPFR_TER_OFFCYC_GP |
Character(18) | VARCHAR2(18) NOT NULL | Off-cycle Calendar Group ID |
| 6 | GPFR_NEW_CAL_GRP | Character(1) | VARCHAR2(1) NOT NULL |
Create New Calendar Group
0=Create New Group 1=Attach to an Existing Group 2=Attach to a Group later Default Value: 0 |
| 7 | GPFR_TERM_GP_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Termination Group created Flag
Y/N Table Edit |