EMPLIDBENEFIT_PLANA=Active
B=Both (Inactive and Active)
D=Done (no liability remaining)
I=Inactive
N=No Record Exist
PA_EMP_VAL(SQL Table) |
Index Back |
|---|---|
Prior Actuarial ValuationThis is an employee table containing Prior Actuarial Valuation. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |
| 3 | PY_VAL_CODE | Character(1) | VARCHAR2(1) NOT NULL |
Prior Year Val Code
A=Active B=Both (Inactive and Active) D=Done (no liability remaining) I=Inactive N=No Record Exist |
| 4 | PY_VAL_DATE | Date(10) | DATE | Prior Actuarial Valuation Date |