FPA_CONTRACT_VW(SQL View) |
Index Back |
|---|---|
Contract Numbers per employeesThis view retrieves the contract numbers per employees. It is used by the French Public Sector functionalities. |
| SELECT A.EMPLID , A.CONTRACT_NUM , A.EMPL_RCD , A.EFFDT , A.ACTION , A.ACTION_REASON , A.EMPL_STATUS , A.JOB_INDICATOR , A.FP_LEGALSTAT_CD FROM PS_FPAEELEGALSTAT A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract Number |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | ACTION | Character(3) | VARCHAR2(3) NOT NULL | Action |
| 6 | ACTION_REASON | Character(3) | VARCHAR2(3) NOT NULL | Reason Code |
| 7 | EMPL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payroll Status
A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration |
| 8 | JOB_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL |
This Indicator is used on JOB to specify which employment record is considered to be the primary one for an employee.
In case of Multiple Jobs per Employee, this property is being used to make a conscious decision in related features where only 1 Employment Record per Employee needs to be returned.
N=Not Applicable P=Primary Job S=Secondary Job |
| 9 | FP_LEGALSTAT_CD | Character(3) | VARCHAR2(3) NOT NULL | Civil Service Position Code |