DEP_BENEF_BRA

(SQL Table)
Index Back

Brazil Dependent Record

Brazil Dependent: Birth Data

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

2 DEPENDENT_BENEF Character(2) VARCHAR2(2) NOT NULL Dependent Benefit
01=default

Prompt Table: DEPENDENT_VW

3 OFFICE_NAME Character(30) VARCHAR2(30) NOT NULL Office Name
4 REGISTRY_NUM_BRA Character(20) VARCHAR2(20) NOT NULL Registry Number Brazil
5 BOOK_NUMBER_BRA Character(20) VARCHAR2(20) NOT NULL Book Number Brazil
6 PAGE_NUMBER_BRA Character(20) VARCHAR2(20) NOT NULL Page Number Brazil
7 DATE_RECEIVED Date(10) DATE Date Received
8 MOTHER_NAME_BRA Character(50) VARCHAR2(50) NOT NULL Dependent Mother Name Employee's Mother Name
9 RG_ISSUED_DT_BRA Date(10) DATE RG Issued DT
10 RG_STATE_BRA Character(6) VARCHAR2(6) NOT NULL RG State

Prompt Table: STATE_BRA_VW

11 RG_AGENCY_BRA Character(10) VARCHAR2(10) NOT NULL RG Public Agency