RC_VC_REP_CHLD (SQL Table)	Index Back
VC Reports Run Control This is the run control record to store input parameters for all of the reports run out of the Variable Compensation module. This record contains some fields that are report specific and will therefore not always be populated, depending upon which report is being run.

RC_VC_REP_CHLD

(SQL Table)

VC Reports Run Control

This is the run control record to store input parameters for all of the reports run out of the Variable Compensation module. This record contains some fields that are report specific and will therefore not always be populated, depending upon which report is being run.

# 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 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: VC_EMPLAWRD_VW

4 FROMDATE Date(10) DATE NOT NULL From Date

5 THRUDATE Date(10) DATE NOT NULL End Date

#	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	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: VC_EMPLAWRD_VW
4	FROMDATE	Date(10)	DATE NOT NULL	From Date
5	THRUDATE	Date(10)	DATE NOT NULL	End Date