SCC_DISABRA_PVW

(SQL View)
Index Back

Disability Brazil view

Disability Brazil staging view

SELECT PROCESS_INSTANCE ,SCC_SEQ_ID ,SCC_SEQ_ID3 ,EMPLID ,EFFDT ,PPP_SITUATION_BRA ,DISABLED_TYPE_BRA ,AUDIT_ACTN FROM PS_SCC_DISABRA_STG

# 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 PPP_SITUATION_BRA Character(3) VARCHAR2(3) NOT NULL PPP Situation Brazil
PDH=Deficiency Carrier Habilitated
REB=Rehabilitated Beneficiary
7 DISABLED_TYPE_BRA Character(1) VARCHAR2(1) NOT NULL Disabled Type for Brazil
0=Not Disabled
1=Physical Disability
2=Hearing Disability
3=Visual Disability
4=Intellectual Disability
5=Multiple Disability
6=Rehabilitated
7=Reduced Mobility.
8 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