GP_PYGRP(SQL Table) |
Index Back |
|---|---|
GP Pay Group Definition |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(10) | VARCHAR2(10) NOT NULL | Pay Group | |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 4 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 5 | START_DT_OPTN_FSCL | Character(2) | VARCHAR2(2) NOT NULL |
Fiscal Start Default Source
Default Value: PE |
| 6 | START_MTH_FSCL | Character(2) | VARCHAR2(2) NOT NULL | Fiscally Yearly Start Month |
| 7 | START_DAY_FSCL | Number(2,0) | SMALLINT NOT NULL | Fiscally Yearly Start Day |
| 8 | USER_FIELD_1 | Character(10) | VARCHAR2(10) NOT NULL | User Field 1 |