PROCESS_INSTANCEEMPLIDPAY_ENTITYBALANCE_GRP_NUMPIN_NUM10=PAYG Non-Business
20=PAYG Voluntary
30=PAYG Foreign
GPAU_FRN_AL_TAO(SQL Table) |
Index Back |
|---|---|
FRN Create - Allowances Temp TFRN Creation - Temporary Table to hold Foreign Allowances |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 4 | BALANCE_GRP_NUM |
Character(3) | VARCHAR2(3) NOT NULL | This field will be used to determine the grouping of balances from the different jobs of the employee. |
| 5 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 6 | PIN_CODE | Character(22) | VARCHAR2(22) NOT NULL | Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across. Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN) |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | GPAU_PSM_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Type of Payment Summary - Non-Business or Voluntary
10=PAYG Non-Business 20=PAYG Voluntary 30=PAYG Foreign |
| 9 | GPAU_PSM_GROSS_PAY | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Gross Pay - End of Year Processing |