PA_SUMMARY_EMP

(SQL Table)
Index Back

Calculation Recap

This is a system table for the Calculation Recap.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CALC_NAME Character(20) VARCHAR2(20) NOT NULL Calculation Name
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 EMPL_NAME Character(50) VARCHAR2(50) NOT NULL Employee Name
5 EMPL_PLAN_CNT Number(3,0) SMALLINT NOT NULL Total Plans for Employee