FPY_PRRPT_LIST

(SQL Table)
Index Back

Progress Report Table

Progress 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