GPBR_DIRF_D_WRK

(SQL Table)
Index Back

Work Table DIRF Dependents

Work Table DIRF Dependents

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 HPROV_CD_BRA Character(10) VARCHAR2(10) NOT NULL Health Provider Code
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 DEPENDENT_BENEF Character(2) VARCHAR2(2) NOT NULL Dependent Benefit
01=default
5 AMOUNT Signed Number(20,3) DECIMAL(18,3) NOT NULL Commuting Allowance Paid Per Cycle.
6 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
7 BIRTHDATE Date(10) DATE Date of Birth
8 NAME Character(50) VARCHAR2(50) NOT NULL Name
9 RELATIONSHIP Character(2) VARCHAR2(2) NOT NULL Relationship to Employee