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 | Character(20) | VARCHAR2(20) NOT NULL | Calculation Name | |
| 2 | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID | |
| 3 | 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 |