EMPLIDEMPL_RCDEFFDTEFFSEQ00=Contract Signed
01=Hiring Done
02=Hiring Validated
FPARATIFY_VW(SQL View) |
Index Back |
|---|---|
ID to be confirmed View |
| SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , B.EFFSEQ , A.FP_LEGALSTAT_CD , A.FP_HIR_DOS_SIT , B.JOBCODE , B.FP_BUSINESS_CD , B.POSITION_NBR , B.COMPANY , B.DEPTID , B.ESTABID , B.BUSINESS_UNIT , B.REG_REGION , B.FP_STEP_CD , B.FP_CHG_SAL FROM PS_FPAEELEGALSTAT A , ps_fpaeepost_tbl B WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.EFFDT = B.EFFDT AND B.EFFSEQ = 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | FP_LEGALSTAT_CD | Character(3) | VARCHAR2(3) NOT NULL | Civil Service Position Code. |
| 6 | FP_HIR_DOS_SIT | Character(2) | VARCHAR2(2) NOT NULL |
Hire Status for FPS
00=Contract Signed 01=Hiring Done 02=Hiring Validated |
| 7 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 8 | FP_BUSINESS_CD | Character(4) | VARCHAR2(4) NOT NULL | Occupation Code |
| 9 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 10 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 11 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 12 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 13 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 14 | REG_REGION | Character(5) | VARCHAR2(5) NOT NULL | Regulatory Region |
| 15 | FP_STEP_CD | Character(4) | VARCHAR2(4) NOT NULL | Step |
| 16 | FP_CHG_SAL | Character(1) | VARCHAR2(1) NOT NULL | Forced Salary |