| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
GPSG_CPF_EMPLR_REF |
Character(15) |
VARCHAR2(15) NOT NULL |
CPF Employer Reference no.
Prompt Table:
GPSG_ER_CPF_REF
|
| 4 |
GPSG_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Character field to represent a year
|
| 5 |
MONTHCD |
Character(2) |
VARCHAR2(2) NOT NULL |
Month
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December
|
| 6 |
BEGIN_DT |
Date(10) |
DATE |
Begin Date
|
| 7 |
END_DT |
Date(10) |
DATE |
end date
|
| 8 |
GPSG_PRINT_CPF |
Character(1) |
VARCHAR2(1) NOT NULL |
Print CPF flag
Y/N Table Edit
Default Value: N
|
| 9 |
GPSG_PRINT_CDAC |
Character(1) |
VARCHAR2(1) NOT NULL |
Print CDAC flag
Y/N Table Edit
Default Value: N
|
| 10 |
GPSG_PRINT_ECF |
Character(1) |
VARCHAR2(1) NOT NULL |
Print ECF flag
Y/N Table Edit
Default Value: N
|
| 11 |
GPSG_PRINT_MBMF |
Character(1) |
VARCHAR2(1) NOT NULL |
Print MBMF flag
Y/N Table Edit
Default Value: N
|
| 12 |
GPSG_PRINT_MBF |
Character(1) |
VARCHAR2(1) NOT NULL |
Mosque Building Fund
|
| 13 |
GPSG_PRINT_YMF |
Character(1) |
VARCHAR2(1) NOT NULL |
Yayasan Mendaki Fund
|
| 14 |
GPSG_PRINT_SINDA |
Character(1) |
VARCHAR2(1) NOT NULL |
Print SINDA
Y/N Table Edit
Default Value: N
|
| 15 |
GPSG_PRINT_SHARE |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Share
Y/N Table Edit
Default Value: N
|
| 16 |
GPSG_PRINT_FWL |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Mosque Building Fund flag
Y/N Table Edit
Default Value: N
|
| 17 |
GPSG_PRINT_SDL |
Character(1) |
VARCHAR2(1) NOT NULL |
Print SDL flag
Y/N Table Edit
Default Value: N
|
| 18 |
GPSG_SUMMARY_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Summary Only
Y/N Table Edit
Default Value: N
|
| 19 |
GPSG_DETAIL_REPORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Detailed report flag
Y/N Table Edit
Default Value: N
|
| 20 |
GPSG_CREATE_DATE |
Date(10) |
DATE NOT NULL |
Creation Date of Singapore IR8A data
Default Value: %date
|
| 21 |
GPSG_AGE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
This field has been created to fetch the report output for CPF Adjustment Report SGP based on the Age Options provided
C=As of Current Date
Y=As of End of Year/Termination
|