| # |
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 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 4 |
GPMY_FROM_DT |
Date(10) |
DATE |
From Date
Default Value: %date
|
| 5 |
GPMY_CONTRIB_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Contribution Year
|
| 6 |
GPMY_TO_DT |
Date(10) |
DATE |
To Date
|
| 7 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table:
GP_PYGRP
|
| 8 |
GPMY_REPRINT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Reprint
Y/N Table Edit
Default Value: N
|
| 9 |
GPMY_FROM_SER_NUM |
Character(5) |
VARCHAR2(5) NOT NULL |
From Serial Number
|
| 10 |
GPMY_THRU_SER_NUM |
Character(5) |
VARCHAR2(5) NOT NULL |
Through Serial Number
|
| 11 |
GPMY_PYGRP_PRNT |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Paygroup
Y/N Table Edit
Default Value: N
|
| 12 |
GPMY_DEP_PRINT |
Character(1) |
VARCHAR2(1) NOT NULL |
Department Print
Y/N Table Edit
Default Value: N
|
| 13 |
GPMY_EMP_SORTORDER |
Character(1) |
VARCHAR2(1) NOT NULL |
Payee Sort order
E=Employee Id
N=Employee Name
T=Tax Reference Number
Default Value: E
|
| 14 |
GPMY_EPF_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
EPF Number
Prompt Table:
%GP_EDIT_FLD1
|
| 15 |
GPMY_TAX_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
GPMY_TAX_NBR
Prompt Table:
%GP_EDIT_FLD1
|
| 16 |
GPMY_SOCSO_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
SOCSO Number
Prompt Table:
%GP_EDIT_FLD1
|
| 17 |
GPMY_REF_NBR |
Character(11) |
VARCHAR2(11) NOT NULL |
Reference Number
Prompt Table:
GPMY_TAX_REF_VW
|
| 18 |
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
Default Value: 01
|
| 19 |
FILENAME |
Character(80) |
VARCHAR2(80) NOT NULL |
File Name
|
| 20 |
GPMY_FILENAMEIN |
Character(80) |
VARCHAR2(80) NOT NULL |
Input File Name
|
| 21 |
GPMY_PRT_MALAY_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Print in Malay
Y/N Table Edit
Default Value: N
|
| 22 |
GPMY_PROCESS_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes / No Field to track on a particular Record : SN
0=Output to Interface file
1=Input from Interface file
Default Value: 0
|
| 23 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 24 |
GPMY_CRT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Create File Indicator
Y/N Table Edit
Default Value: N
|
| 25 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
%GP_EDIT_FLD2
|
| 26 |
ORG_LINK_UNIT |
Character(12) |
VARCHAR2(12) NOT NULL |
Contains ID of an org unit to which a source bank is assigned. can be Company, Dept, Location, Pay Group or Pay Entity ID
Prompt Table:
%RECNAME_EDIT
|
| 27 |
GPMY_ORG_LINK_OPTN |
Character(2) |
VARCHAR2(2) NOT NULL |
Organizational Link Option
CO=Company
DE=Department
ET=Establishment
LO=Location
PG=Pay Group
Default Value: CO
|
| 28 |
GPMY_STATUS_CODE |
Character(2) |
VARCHAR2(2) NOT NULL |
Status Code of the Employer
01=Government
02=Government(comp)
03=Statutory
04=Statutory(comp)
05=Private
06=Private(comp)
07=Public Education Centre
08=Public Education Centre(comp)
09=Private Education Centre
10=Private Education Centre(comp)
11=Army
|
| 29 |
GPMY_TAX_REF_CODE |
Character(2) |
VARCHAR2(2) NOT NULL |
Employer's Income Tax reference Number
01=SG
02=OG
03=Partnership
04=Company
05=Hindu Joint Family
06=Association
07=Desceased Person's Estate
08=Trust Body
09=Unit/Real Property Trust
10=Co-Operative Society
|
| 30 |
GPMY_BNK_USRNO |
Character(12) |
VARCHAR2(12) NOT NULL |
Bank User Number
|
| 31 |
GPMY_DEPOSIT_DT |
Date(10) |
DATE |
Date of Deposit of EFT payments for MYS
|
| 32 |
BANK_NM |
Character(40) |
VARCHAR2(40) NOT NULL |
Bank Name
|