GPJP_PP_POS(SQL Table) |
Index Back |
---|---|
Pay Slip Template PositionsTracks a list of the positions available for use in designing the pay slip template. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GPJP_POSITION | Character(6) | VARCHAR2(6) NOT NULL | Tracks the position of an element on a pay slip. The first two digits indicate the section that the element is displayed, the next two indicate the row, and the last two indicate the column. |
2 | GPJP_SECTION | Character(2) | VARCHAR2(2) NOT NULL | Section. |
3 | GPJP_ROW | Character(2) | VARCHAR2(2) NOT NULL | Row. |
4 | GPJP_COLUMN | Character(2) | VARCHAR2(2) NOT NULL | Column. |
5 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type Code
N=Customer Data S=Sample Data Y=System Data Default Value: N |