FPY_PRCSD_VW(SQL View) |
Index Back |
|---|---|
Processed Persons and PositionProcessed Persons and Positions |
| SELECT 'P' ,A.FPY_BUS_OBJ ,A.EMPLID ,A.FPY_PERSON_NUM ,A.FPY_PROCESSED_FLG ,A.FPY_MODE ,B.rundttm FROM PS_FPY_PERSON_TBL A ,PSPRCSRQST B WHERE A.PROCESS_INSTANCE=B.prcsinstance AND A.FPY_PROCESSED_FLG='Y' UNION ALL SELECT 'S' ,C.FPY_BUS_OBJ , C.POSITION_NBR ,C.FPY_POSITION_CODE ,C.FPY_PROCESSED_FLG ,C.FPY_MODE ,D.RUNDTTM FROM PS_FPY_POS_STG_TBL C ,PSPRCSRQST D WHERE C.PROCESS_INSTANCE=D.prcsinstance AND C.FPY_PROCESSED_FLG='Y' UNION ALL SELECT 'D' ,D.FPY_BUS_OBJ , D. DEPTID ,%NumToChar(D.FPY_DEPT_ID ) ,D.FPY_PROCESSED_FLG ,D.FPY_MODE ,D1.RUNDTTM FROM PS_FPY_DEP_STG_TBL D ,PSPRCSRQST D1 WHERE D.PROCESS_INSTANCE=D1.prcsinstance AND D.FPY_PROCESSED_FLG='Y' UNION ALL SELECT 'L' ,D.FPY_BUS_OBJ , D. LOCATION ,D. FPY_LOCATION_CD ,D.FPY_PROCESSED_FLG ,D.FPY_MODE ,D1.RUNDTTM FROM PS_FPY_LOC_STG_TBL D ,PSPRCSRQST D1 WHERE D.PROCESS_INSTANCE=D1.prcsinstance AND D.FPY_PROCESSED_FLG='Y' UNION ALL SELECT 'O' ,D.FPY_BUS_OBJ , D.JOBCODE ,%NumToChar(D.FPY_JOB_ID) ,D.FPY_PROCESSED_FLG ,D.FPY_MODE ,D1.RUNDTTM FROM PS_FPY_JCD_STG_TBL D ,PSPRCSRQST D1 WHERE D.PROCESS_INSTANCE=D1.prcsinstance AND D.FPY_PROCESSED_FLG='Y' UNION ALL SELECT 'C' ,D.FPY_BUS_OBJ , D.COMPANY ,%NumToChar(D.FPY_LEGALENTITY_ID ) ,D.FPY_PROCESSED_FLG ,D.FPY_MODE ,D1.RUNDTTM FROM PS_FPY_COMPANY_STG D ,PSPRCSRQST D1 WHERE D.PROCESS_INSTANCE=D1.prcsinstance AND D.FPY_PROCESSED_FLG='Y' UNION ALL SELECT 'U' ,D.FPY_BUS_OBJ , D.BUSINESS_UNIT ,D.FPY_BUSINESS_UNIT ,D.FPY_PROCESSED_FLG ,D.FPY_MODE ,D1.RUNDTTM FROM PS_FPY_BU_STG_TBL D ,PSPRCSRQST D1 WHERE D.PROCESS_INSTANCE=D1.prcsinstance AND D.FPY_PROCESSED_FLG='Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FPY_BO_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Business Object Type
A=All B=Bonus C=Company D=Department E=Absence J=Job Data L=Location O=Job Code P=Person Details S=Position Data U=Business Unit |
| 2 | FPY_BUS_OBJ | Character(3) | VARCHAR2(3) NOT NULL |
Business Object
ABS=Absence ADD=Person Address ALL=All BNS=Bonus BUS=Business Unit CCI=Company CMP=Compensation Data COM=Company DCI=Department DEP=Department EML=Person Email JCD=JobCode JCI=Job Data JOB=Job Data LCI=Location LEG=Person Legislative Data LOC=Location NAM=Person Name NID=Person National Identifier OCI=JobCode ORG=Organisation Instance PCI=Person PER=Person PHN=Person Phone POS=Position SCI=Position |
| 3 | FPY_PS_IDENTIFIER | Character(120) | VARCHAR2(120) NOT NULL | Peoplesoft Identifier |
| 4 | FPY_IDENTIFIER | Character(254) | VARCHAR2(254) NOT NULL | Fusion Identifier |
| 5 | FPY_PROCESSED_FLG | Character(1) | VARCHAR2(1) NOT NULL | Processed Flag |
| 6 | FPY_MODE | Character(1) | VARCHAR2(1) NOT NULL | FPY_MODE |
| 7 | FPY_EXECDTTM | DateTime(26) | TIMESTAMP | Last Run Datetime |