GP_PAYGROUPPrompt Table: GPFR_TERPYGP_VW
CAL_PRD_IDPrompt Table: GPFR_TER_PRD_VW
GPFR_TERM_GROUP_IDCOUNTRYA=Cash
C=Check
O=Pay Primary Account Only
P=Postal Order
T=Bank Transfer
U=Use Normal Distribution
W=Wire Transfer
Default Value: C
GPFR_TERM_GROUP(SQL Table) |
Index Back |
|---|---|
Termination GroupPrimary table for Termination Group |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table: GPFR_TERPYGP_VW |
| 2 | CAL_PRD_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Calendar Period ID
Prompt Table: GPFR_TER_PRD_VW |
| 3 | GPFR_TERM_GROUP_ID |
Character(15) | VARCHAR2(15) NOT NULL | Termination Group ID |
| 4 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | GPFR_ASS_PAY_DATE | Date(10) | DATE NOT NULL | GPFR: Date of Pay |
| 7 | PAYMENT_MTHD | Character(1) | VARCHAR2(1) NOT NULL |
Payment Method
A=Cash C=Check O=Pay Primary Account Only P=Postal Order T=Bank Transfer U=Use Normal Distribution W=Wire Transfer Default Value: C |