GPMY_RC_FA_POST(SQL Table) |
Index Back |
|---|---|
Festive Advance Run CtlRun Control record for Malaysia Festive Advance GP Posting process |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: PRCSRUNCNTL.OPRID |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Run Control ID
Default Value: PRCSRUNCNTL.RUN_CNTL_ID |
| 3 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table: GP_PYGRP |
| 4 | CAL_ID | Character(18) | VARCHAR2(18) NOT NULL |
calendar id
Prompt Table: GPMY_FA_CAL_VW |
| 5 | CALENDAR_YEAR | Number(4,0) | SMALLINT NOT NULL | Calendar Year |
| 6 | FA_CHINESE_NY | Character(1) | VARCHAR2(1) NOT NULL |
Chinese New Year
Y/N Table Edit Default Value: N |
| 7 | FA_CHRISTMAS | Character(1) | VARCHAR2(1) NOT NULL |
Festive Advance Type Christmas
Y/N Table Edit Default Value: N |
| 8 | GPMY_FA_PROC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
GP Malaysia Festive Advance interface processing type (Post or Unpost)
P=Post U=UnPost |
| 9 | FA_DEEPAVALI | Character(1) | VARCHAR2(1) NOT NULL |
Festive Advance Deepavali
Y/N Table Edit Default Value: N |
| 10 | FA_HARI_RAYA | Character(1) | VARCHAR2(1) NOT NULL |
Festive Advance Type Hari Raya
Y/N Table Edit Default Value: N |