PAY_ENTITYBUSINESS_UNITGROUPING_CODE10=Salary
20=Accrual
30=Employee Entitlements
40=Terminated Ee's Entitlement
50=Statistics
GP_GLGRP_SGPMY(SQL Table) |
Index Back |
|---|---|
Journal TypesJournal types are used to identify transactions for the different journal types. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | GROUPING_CODE |
Character(15) | VARCHAR2(15) NOT NULL | Identifier (name) used to group a number of elements (earnings or deductions) that can be treated equally (posted to the same account) for GL purposes. |
| 4 | GPMY_JOURNAL_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Journal Type values are:
10 - Salary
20 - Accrual
30 - Employee Entitlements
40 - Terminated Ee's Entitlements
50 - Statistics
10=Salary 20=Accrual 30=Employee Entitlements 40=Terminated Ee's Entitlement 50=Statistics |