PA_DFN_COV_COMP(SQL Table) |
Index Back |
|---|---|
Covered CompensationThis is a setup table containing Covered Compensation parameters. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  DEFINITION_NAME |
Character(10) | VARCHAR2(10) NOT NULL | VARCHAR2(10) NOT NULL |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | TBL_EFFDT | Date(10) | DATE | Use Table in Effect on |
| 4 | TBL_EFFDT_ALIAS | Character(10) | VARCHAR2(10) NOT NULL |
Use Table in Effect on
Prompt Table: PA_DTDB_ALS_VW |
| 5 | COMP_BASIS | Character(1) | VARCHAR2(1) NOT NULL |
Covered Compensation Basis
A=Annual M=Monthly Default Value: A |
| 6 | ROUNDED_TBL | Character(1) | VARCHAR2(1) NOT NULL |
Use Rounded Table
Y/N Table Edit |
| 7 | ROUND_EFFDT | Character(1) | VARCHAR2(1) NOT NULL |
Apply $3000 Rounding Effective
A=1990 Plan Year Determination B=1994 Plan Year Determine C=Apply 600 for All Plan Years D=Apply 3000 all Plan Years N=No Rounding Default Value: N |
| 8 | EXCLUDE_SSRA | Character(1) | VARCHAR2(1) NOT NULL |
Exclude Year of SSRA from Avg
Y/N Table Edit |
| 9 | USE_COV_COMP | Character(1) | VARCHAR2(1) NOT NULL |
Use Covered Comp in Effect on
Y/N Table Edit |
| 10 | TBL_EFFDT_ALIAST | Character(2) | VARCHAR2(2) NOT NULL |