FPASENDUR_CALC(SQL Table) |
Index Back |
|---|---|
Seniority / Lenght of ServiceThis table stores the seniority and lenght of service for all the employees. It is used by the French Public Sector functionalities. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | START_DATE | Date(10) | DATE NOT NULL | Start Date for Gen Standing PO |
| 4 | END_DATE | Date(10) | DATE |
End Date
Default Value: %date |
| 5 | FP_TRUESEN_DY | Number(2,0) | SMALLINT NOT NULL |
Step Actual Seniority (D)
Default Value: 0 |
| 6 | FP_TRUESEN_MN | Number(2,0) | SMALLINT NOT NULL |
Step Actual Seniority (M)
Default Value: 0 |
| 7 | FP_TRUESEN_YR | Number(2,0) | SMALLINT NOT NULL |
Actual Step Seniority (Y)
Default Value: 0 |
| 8 | FP_DURSTEP_DY | Number(2,0) | SMALLINT NOT NULL |
Step Service Length (Days)
Default Value: 0 |
| 9 | FP_DURSTEP_MN | Number(2,0) | SMALLINT NOT NULL |
Step Service Length (Months)
Default Value: 0 |
| 10 | FP_DURSTEP_YR | Number(2,0) | SMALLINT NOT NULL |
Step Service Length (Years)
Default Value: 0 |