PA_SUMMARY_EMP(SQL Table) |
Index Back |
---|---|
Calculation RecapThis 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 |