FPY_PRRPT_LIST(SQL Table) |
Index Back |
---|---|
Progress Report TableProgress Report Table |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | FPY_PARENT_INST | Number(10,0) | DECIMAL(10) NOT NULL | Parent Instance |
2 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
3 | 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 |
4 | 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 |
5 | FPY_TOTAL_ROWS | Number(15,0) | DECIMAL(15) NOT NULL | Total rows |
6 | FPY_ERROR_ROWS | Number(15,0) | DECIMAL(15) NOT NULL | Processed rows with Error |
7 | FPY_SUCCESS_ROWS | Number(15,0) | DECIMAL(15) NOT NULL | Successful Rows |
8 | FPY_INT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Taleo Integration Status
C=Completed With Errors E=In Error I=Initiated N=Not Initiated P=In Progress S=Success W=Completed with Warning |