FPY_RPT_RUN (SQL Table)	Index Back
Run Control Record for Reports

FPY_RPT_RUN

(SQL Table)

Run Control Record for Reports

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

4 FPY_REPORT_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Report
D=Detailed Reports
S=Summary Report
Default Value: S

5 FPY_RPT_BUS_OBJ Character(3) VARCHAR2(3) NOT NULL Report Business Object
ALL=All
PER=Employee Details
SET=Setup Entities
Default Value: ALL

6 FPY_RPT_CONDITION Character(3) VARCHAR2(3) NOT NULL Report Condition
ALL=All
CWR=Contigent Worker
EMP=Employee
POI=Person of Interest
SBU=Business Unit
SCO=Company
SDP=Department
SJC=Job Code
SLC=Location
SPO=Position
Default Value: ALL

7 FPY_EXECDTTM DateTime(26) TIMESTAMP Last Run Datetime

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	FPY_REPORT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Type of Report D=Detailed Reports S=Summary Report Default Value: S
5	FPY_RPT_BUS_OBJ	Character(3)	VARCHAR2(3) NOT NULL	Report Business Object ALL=All PER=Employee Details SET=Setup Entities Default Value: ALL
6	FPY_RPT_CONDITION	Character(3)	VARCHAR2(3) NOT NULL	Report Condition ALL=All CWR=Contigent Worker EMP=Employee POI=Person of Interest SBU=Business Unit SCO=Company SDP=Department SJC=Job Code SLC=Location SPO=Position Default Value: ALL
7	FPY_EXECDTTM	DateTime(26)	TIMESTAMP	Last Run Datetime