EMPLIDEMPL_RCDEFFDTDefault Value: PER_ORG_ASGN_VW.HIRE_DT
ACCIDENT_INSDefault Value: GPDE_SI_COOP_P.ACCIDENT_INS
HAZARDPrompt Table: ACCDT_INS_HAZ
GPDE_SI_COOP_D(SQL Table) |
Index Back |
|---|---|
Employer Liability InsuranceEE Employer Liability Ins |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: PER_ORG_ASGN_VW.HIRE_DT |
| 4 | ACCIDENT_INS |
Character(15) | VARCHAR2(15) NOT NULL |
Accident Insurance
Default Value: GPDE_SI_COOP_P.ACCIDENT_INS |
| 5 | HAZARD |
Character(8) | VARCHAR2(8) NOT NULL |
Hazard
Prompt Table: ACCDT_INS_HAZ |
| 6 | GPDE_AI_HAZ_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Distribution Percentage for Hazard on EE base. |