GPMY_RCPPYE(SQL Table) |
Index Back |
---|---|
Recipient Payee Sibling RecordRecipient Payee sibling record for Malaysia customers. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
2 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL |
Empl Record
Default Value: 0 |
3 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
4 | RECIPIENT_ID | Character(8) | VARCHAR2(8) NOT NULL |
Payment recipient ID
Prompt Table: RECIPIENT |
5 | GPMY_MEMBER_ID | Character(15) | VARCHAR2(15) NOT NULL | This is the employees membership id number issued by a recipient organization to identify the employee. |
6 | GPMY_MEMBERSHIP_TY | Character(1) | VARCHAR2(1) NOT NULL |
Indicates whether the employee's Membership ID assigned to him/her by a recipient is the same value as the employee's primary national ID.
Y/N Table Edit Default Value: N |
7 | GPMY_ALL_DED_SW | Character(1) | VARCHAR2(1) NOT NULL |
Indicates whether membership id specified for payee recipient details applies to all deductions for the recipient or only to specific deductions.
Y/N Table Edit Default Value: Y |