SCC_PERDBRA_PVW

(SQL View)
 Index Back

SELECT A.PROCESS_INSTANCE , A.SCC_SEQ_ID , A.SCC_SEQ_ID3 , A.EMPLID , A.EFFDT , A.ETHNIC_GROUP_BRA , A.NATIONALITY_CD_BRA , A.EDUCATION_LVL_BRA , A.AUDIT_ACTN FROM PS_SCC_PERDBRA_STG A WHERE A.AUDIT_ACTN IN ('C', 'A')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SCC_SEQ_ID Number(10,0) DECIMAL(10) NOT NULL Sequence ID
3 SCC_SEQ_ID3 Number(3,0) SMALLINT NOT NULL Sequence Nbr
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 EFFDT Date(10) DATE Effective Date
6 ETHNIC_GROUP_BRA Character(2) VARCHAR2(2) NOT NULL Ethnic Group Brazil
01=Native
02=White
04=Black
06=Yellow
08=Brown
09=Non Informed
7 NATIONALITY_CD_BRA Character(2) VARCHAR2(2) NOT NULL Nationality code Brazil
8 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
9 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values