VC_PRO_PRDS_AET(SQL Table) |
Index Back |
|---|---|
VC Prorate Prds State RecordThis 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
|
| 9 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |