HR_EMT1BR_AET

(SQL Table)
Index Back

Employee Registry BRA

Employee Registry Report Temp 1 BRA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
6 REG_NUMBER_BRA Character(11) VARCHAR2(11) NOT NULL Employee Registration Number
7 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
8 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
9 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
10 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
11 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
12 CITY Character(30) VARCHAR2(30) NOT NULL City
13 STATE Character(6) VARCHAR2(6) NOT NULL State
14 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
15 TERMINATION_DT Date(10) DATE Termination Date
16 SERVICE_DT Date(10) DATE Service Date
17 GPBR_FGTS_DT Date(10) DATE FGTS Date
18 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
19 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
20 HOURLY_RT Number(19,6) DECIMAL(18,6) NOT NULL Hourly Rate
21 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
22 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
23 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
24 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
25 DESCR Character(30) VARCHAR2(30) NOT NULL Description
26 JOB_FUNCTION Character(3) VARCHAR2(3) NOT NULL Job Function Code
27 DUR Date(10) DATE Date Under Report associates time being reported, scheduled or paid, to a specific date.
28 NAME Character(50) VARCHAR2(50) NOT NULL Name
29 CONT_SAL_TYPE_BRA Character(1) VARCHAR2(1) NOT NULL Contract Salary Type Brazil
1=Monthly
2=Fortnightly
3=Weekly
4=Daily
5=Hourly
6=Per Task
7=Commission
8=Other
30 DES_SAL_TYPE_BRA Character(30) VARCHAR2(30) NOT NULL Salary type
31 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type
32 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
33 PASSPORT_NBR Character(15) VARCHAR2(15) NOT NULL Passport Number
34 DT_ISSUED Date(10) DATE Issue Date
35 BIRTHCOUNTRY Character(3) VARCHAR2(3) NOT NULL Birth Country
36 RELATIONSHIP Character(2) VARCHAR2(2) NOT NULL Relationship to Employee
37 MAR_STATUS Character(1) VARCHAR2(1) NOT NULL Marital Status
C=Common-Law
D=Divorced
E=Separated
H=Head of Household
L=DissDeclLost Civil Partner
M=Married
P=Civil Partnership
S=Single
T=Surviving Civil Partner
U=Unknown
V=Dissolved Civil Partnership
W=Widowed
38 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
39 GPBR_CIPA_TITLE Number(1,0) SMALLINT NOT NULL Cipa's Titleholder/Substitute
40 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment
41 LICENSE_NBR Character(15) VARCHAR2(15) NOT NULL License/Certification Number
42 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
43 EFFDT Date(10) DATE Effective Date
44 EFFSEQ_BRA Number(5,0) INTEGER NOT NULL Effective Sequence
45 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
46 ACTION Character(3) VARCHAR2(3) NOT NULL Action
47 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
48 AMOUNT Signed Number(20,3) DECIMAL(18,3) NOT NULL Commuting Allowance Paid Per Cycle.
49 UNION_CD Character(3) VARCHAR2(3) NOT NULL Union Code
50 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID
51 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
52 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
53 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
54 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take
55 BGN_DT Date(10) DATE Begin Date
56 END_DT Date(10) DATE end date
57 EVT_CONFIG1 Character(10) VARCHAR2(10) NOT NULL config char
58 ABS_TYPE_OPTN Character(3) VARCHAR2(3) NOT NULL Absence Type
59 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
60 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
61 LEGAL_ENT_TYPE_BRA Character(3) VARCHAR2(3) NOT NULL Legal Entity Type Brazil (Company Name for Legal Reports)
COM=Company
EST=Establishment
62 ESTAB_ID_BRA Character(20) VARCHAR2(20) NOT NULL Establishment ID Brazil
63 COUNTY_CD_BRA Number(7,0) INTEGER NOT NULL COUNTY_CD_BRA County Code
64 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID
65 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
66 BIRTHDATE Date(10) DATE Date of Birth
67 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location
68 BIRTHSTATE Character(6) VARCHAR2(6) NOT NULL Birth State
69 RG_ISSUEDBY_BRA Character(20) VARCHAR2(20) NOT NULL RG Issued By
70 RG_ISSUED_DT_BRA Date(10) DATE RG Issued DT
71 RG_STATE_BRA Character(6) VARCHAR2(6) NOT NULL RG State
72 CTPS_SERIES_BRA Character(5) VARCHAR2(5) NOT NULL CTPS Series
73 CTPS_EXP_DT_BRA Date(10) DATE CTPS Expedition Date
74 VOTER_ZONE_BRA Character(3) VARCHAR2(3) NOT NULL Voter Zone
75 VOTER_SECTION_BRA Character(4) VARCHAR2(4) NOT NULL Voter Section
76 MILITAR_CAT_BRA Character(2) VARCHAR2(2) NOT NULL Military Category
01=First
02=Second
03=Third
04=Dispense
05=Other
77 DES_MILITA_CAT_BRA Character(30) VARCHAR2(30) NOT NULL Military Category
78 PIS_PASEP_DT_BRA Date(10) DATE PIS/PASEP Date Brazil
79 NAME_FORMAL Character(60) VARCHAR2(60) NOT NULL Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
80 VISA_WRKPMT_NBR Character(15) VARCHAR2(15) NOT NULL Visa/Permit Number
81 VISA_WRKPMT_STATUS Character(1) VARCHAR2(1) NOT NULL Visa/Permit Status
A=Applied For
C=Cancelled
G=Granted
N=Renewed
R=Renewal
82 DES_VISA_STAT_BRA Character(30) VARCHAR2(30) NOT NULL Visa Workpermit Status
83 ENTRY_DT Date(10) DATE This field pertains to the date a person enters a country on a specific visa.
84 DRIVERS_LIC_NBR Character(20) VARCHAR2(20) NOT NULL Driver's License Nbr
85 VALID_FROM_DT Date(10) DATE Valid from
86 EXPIRATN_DT Date(10) DATE Expiration Date
87 DES_MAR_STA_BRA Character(30) VARCHAR2(30) NOT NULL Marital Status Description
88 EDUCATION_LVL_BRA Character(2) VARCHAR2(2) NOT NULL Education Level Brazil
01=Analphabet
02=5th (4th old) Grade Incomplete
03=5th (4th old) Grade Complete
04=6th to 9th Grade Incomplete
05=Elementary School Complete
06=Medium School Incomplete
07=Medium School Complete
08=University Incomplete
09=University Complete
10=Post Graduation/Specialization
11=Post Graduation -- Complete
12=Master Degree -- Incomplete
13=Master Degree -- Complete
14=Ph Degree -- Incomplete
15=Ph Degree -- Complete
16=Post Ph Degree -- Incomplete
17=Post Ph Degree -- Complete
89 DES_EDU_LVL_BRA Character(30) VARCHAR2(30) NOT NULL Education level description
90 NATIONALITY_CD_BRA Character(3) VARCHAR2(3) NOT NULL Nationality code Brazil
91 DES_NATIONAL_BRA Character(30) VARCHAR2(30) NOT NULL Nationality Description
92 NUM_CHILDREN_BRA Number(2,0) SMALLINT NOT NULL Number of Children
93 NUM_BRACHILD_BRA Number(2,0) SMALLINT NOT NULL Number of Brazilian Children
94 CBO_CD_BRA Character(7) VARCHAR2(7) NOT NULL Occupation Code for Brazil
95 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code
96 VISA_PERMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Visa/Permit Type
97 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
98 EXPIRATION_DT Date(10) DATE Expiration Date
99 CTPS_STATE_BRA Character(6) VARCHAR2(6) NOT NULL CTPS State

Prompt Table: STATE_BRA_VW

100 MIL_CERT_TYPE_BRA Character(2) VARCHAR2(2) NOT NULL Military Certificate Type
01=Marine
02=Army
03=Aeronautic
04=Other
101 ISSUED_BY_FRA Character(20) VARCHAR2(20) NOT NULL Issuing Authority
102 ISSUE_DEST_FRA Character(20) VARCHAR2(20) NOT NULL Issue Location
103 LICENSE_TYPE Character(4) VARCHAR2(4) NOT NULL License Type
C=Car
CH=Chauffeur
M=Motorcycle
T=Truck
104 COMP_EFFSEQ Number(3,0) SMALLINT NOT NULL Compensation Eff Sequence
105 GPBR_UN_CD_AUX Character(40) VARCHAR2(40) NOT NULL Auxiliary Union code for WA Payee Union related
106 RG_END_DT_BRA Date(10) DATE RG Expiration Date
107 CTPS_END_DT_BRA Date(10) DATE CTPS Expiration Date
108 NATURAL_DT_BRA Date(10) DATE Naturalization Date
109 NATIONAL_ID_FLG Character(1) VARCHAR2(1) NOT NULL Display National ID Online
110 SPOUSE_IND_BRA Character(1) VARCHAR2(1) NOT NULL Brazilian Spouse Indicator
111 CHILDREN_IND_BRA Character(1) VARCHAR2(1) NOT NULL Brazilian Children
112 WRKDAY_ID Character(10) VARCHAR2(10) NOT NULL Workday ID
113 PUNCH_TIME Time(15) TIMESTAMP punch time
114 PUNCH_TYPE Character(2) VARCHAR2(2) NOT NULL Global Punch Types
0=Elapsed
1=In
2=Out
3=Meal
4=Break
5=Transfer