EMPLIDPrompt Table: PA_PRIME_VW
BENEFIT_PLANPrompt Table: PA_BEN_PLAN_VW
USE_ALL_PLANSY/N Table Edit
Default Value: Y
EFFDTDefault Value: %date
Prompt Table: JOB
N=Stop Primary
Y=Start Primary
Default Value: Y
PA_PRIMJOB_OVRD(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PA_PRIME_VW |
| 2 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL |
Benefit Plan
Prompt Table: PA_BEN_PLAN_VW |
| 3 | USE_ALL_PLANS |
Character(1) | VARCHAR2(1) NOT NULL |
All Benefit Plans
Y/N Table Edit Default Value: Y |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL |
Empl Rcd Nbr
Prompt Table: JOB |
| 6 | PRIMARY_JOB_IND | Character(1) | VARCHAR2(1) NOT NULL |
Primary Job used by applications other than HR
N=Stop Primary Y=Start Primary Default Value: Y |