SETIDPrompt Table: SET_LAB_VLD_VW
LABOR_AGREEMENTEFFDTDefault Value: %date
SEQNUMDefault Value: 99
Prompt Table: CURRENCY_CD_TBL
GPES_LBR_SEN(SQL Table) |
Index Back |
|---|---|
Labor agreement seniorityLabor agreement seniority setup data. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SET_LAB_VLD_VW |
| 2 | LABOR_AGREEMENT |
Character(6) | VARCHAR2(6) NOT NULL | Labor Agreement |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 5 | GPES_SEN_MEASU | Number(2,0) | SMALLINT NOT NULL | Seniority measurement, i.e. Trienniums |
| 6 | GPES_SEN_OCCURS | Number(2,0) | SMALLINT NOT NULL |
Number of times a seniority segment occurs
Default Value: 99 |
| 7 | GPES_SEN_AMT | Number(9,2) | DECIMAL(8,2) NOT NULL | Seniority flat amount |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 9 | GPES_SEN_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Seniority percentage over a base |