PPP_RESP_BRA

(SQL Table)
Index Back

PPP Responsible Information

PPP Responsible Information for Brazil

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_HR.SETID

Prompt Table: SET_JOBC_VLD_VW

2 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL

3 BEGIN_DT Date(10) DATE Begin Date
4 PPP_INFO_TYPE_BRA Character(1) VARCHAR2(1) NOT NULL PPP Information Type
A=Environmental Conditions
B=Biological Monitoring
P=PPP Information
5 END_DT Date(10) DATE end date
6 PPP_RESP_TYPE_BRA Character(3) VARCHAR2(3) NOT NULL Responsible Type Brazil
EMP=Employee
NOE=Non Employee
7 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: %GP_EDIT_FLD1

8 PPP_COMMENTS_BRA Character(50) VARCHAR2(50) NOT NULL PPP Comments
9 CODE_TYPE_BRA Character(10) VARCHAR2(10) NOT NULL Class Counseling Code
10 CLASS_TYPE_BRA Character(1) VARCHAR2(1) NOT NULL Class Type
D=Definitive
P=Provisional
11 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Default Value: OPR_DEF_TBL_HR.COUNTRY

Prompt Table: COUNTRY_TBL

12 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL