SCC_PERSBRA_PVW

(SQL View)

SELECT A.PROCESS_INSTANCE , A.SCC_SEQ_ID , A.SCC_SEQ_ID3 , A.EMPLID , A.RG_ISSUEDBY_BRA , A.RG_ISSUED_DT_BRA , A.RG_STATE_BRA , A.CTPS_SERIES_BRA , A.CTPS_EXP_DT_BRA , A.CTPS_STATE_BRA , A.VOTER_ZONE_BRA , A.VOTER_SECTION_BRA , A.VOTER_CITY_BRA , A.VOTER_STATE_BRA , A.MILITAR_SERIES_BRA , A.MILITAR_REGION_BRA , A.MILITAR_STATE_BRA , A.MIL_CERT_TYPE_BRA , A.MILITAR_CAT_BRA , A.PIS_PASEP_DT_BRA , A.AUDIT_ACTN FROM PS_SCC_PERSBRA_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 RG_ISSUEDBY_BRA Character(5) VARCHAR2(5) NOT NULL RG Issued By

6 RG_ISSUED_DT_BRA Date(10) DATE RG Issued DT

7 RG_STATE_BRA Character(6) VARCHAR2(6) NOT NULL RG State

8 CTPS_SERIES_BRA Character(5) VARCHAR2(5) NOT NULL CTPS Series

9 CTPS_EXP_DT_BRA Date(10) DATE CTPS Expedition Date

10 CTPS_STATE_BRA Character(6) VARCHAR2(6) NOT NULL CTPS State

11 VOTER_ZONE_BRA Character(3) VARCHAR2(3) NOT NULL Voter Zone

12 VOTER_SECTION_BRA Character(4) VARCHAR2(4) NOT NULL Voter Section

13 VOTER_CITY_BRA Character(30) VARCHAR2(30) NOT NULL Voter City

14 VOTER_STATE_BRA Character(6) VARCHAR2(6) NOT NULL Voter State

15 MILITAR_SERIES_BRA Character(1) VARCHAR2(1) NOT NULL Military Series

16 MILITAR_REGION_BRA Character(2) VARCHAR2(2) NOT NULL Military Region

17 MILITAR_STATE_BRA Character(6) VARCHAR2(6) NOT NULL Military State Brazil

18 MIL_CERT_TYPE_BRA Character(2) VARCHAR2(2) NOT NULL Military Certificate Type
01=Marine
02=Army
03=Aeronautic
04=Other

19 MILITAR_CAT_BRA Character(2) VARCHAR2(2) NOT NULL Military Category
01=First
02=Second
03=Third
04=Dispense
05=Other

20 PIS_PASEP_DT_BRA Date(10) DATE PIS/PASEP Date Brazil

21 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

#	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	RG_ISSUEDBY_BRA	Character(5)	VARCHAR2(5) NOT NULL	RG Issued By
6	RG_ISSUED_DT_BRA	Date(10)	DATE	RG Issued DT
7	RG_STATE_BRA	Character(6)	VARCHAR2(6) NOT NULL	RG State
8	CTPS_SERIES_BRA	Character(5)	VARCHAR2(5) NOT NULL	CTPS Series
9	CTPS_EXP_DT_BRA	Date(10)	DATE	CTPS Expedition Date
10	CTPS_STATE_BRA	Character(6)	VARCHAR2(6) NOT NULL	CTPS State
11	VOTER_ZONE_BRA	Character(3)	VARCHAR2(3) NOT NULL	Voter Zone
12	VOTER_SECTION_BRA	Character(4)	VARCHAR2(4) NOT NULL	Voter Section
13	VOTER_CITY_BRA	Character(30)	VARCHAR2(30) NOT NULL	Voter City
14	VOTER_STATE_BRA	Character(6)	VARCHAR2(6) NOT NULL	Voter State
15	MILITAR_SERIES_BRA	Character(1)	VARCHAR2(1) NOT NULL	Military Series
16	MILITAR_REGION_BRA	Character(2)	VARCHAR2(2) NOT NULL	Military Region
17	MILITAR_STATE_BRA	Character(6)	VARCHAR2(6) NOT NULL	Military State Brazil
18	MIL_CERT_TYPE_BRA	Character(2)	VARCHAR2(2) NOT NULL	Military Certificate Type 01=Marine 02=Army 03=Aeronautic 04=Other
19	MILITAR_CAT_BRA	Character(2)	VARCHAR2(2) NOT NULL	Military Category 01=First 02=Second 03=Third 04=Dispense 05=Other
20	PIS_PASEP_DT_BRA	Date(10)	DATE	PIS/PASEP Date Brazil
21	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