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 |