VC_PRO_PRDS_AET

(SQL Table)
Index Back

VC Prorate Prds State Record

This record is the 'state' record for the Calculate Proration Periods Application Engine program in Variable Compensation. This records stores the process instance, all input parameters from the run control, as well as any fields requiring 'working' storage during processing.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 PRD_BGN_DT Date(10) DATE Period Begin Date
5 PRD_END_DT Date(10) DATE Pay Period End Date
6 VC_ELIG_PRO_DAYS Number(8,3) DECIMAL(7,3) NOT NULL Days Eliglble In Period
7 TEMP_FLD Character(1) VARCHAR2(1) NOT NULL Temporary Field for App Engine
8 VC_PAYOUT_PRD_ID Character(10) VARCHAR2(10) NOT NULL Payout Period ID

Prompt Table: VC_PAYPRD_TBL
Set Control Field: VC_PAYOUT_PRD_ID

9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID