SCC_VISA_PVW

(SQL View)
 Index Back

Visa change messaging table


SELECT A.PROCESS_INSTANCE , A.SCC_SEQ_ID , A.SCC_SEQ_ID3 , A.EMPLID , A.DEPENDENT_ID , A.COUNTRY , A.VISA_PERMIT_TYPE , A.EFFDT , A.VISA_WRKPMT_NBR , A.VISA_WRKPMT_STATUS , A.STATUS_DT , A.DT_ISSUED , A.PLACE_ISSUED , A.DURATION_TIME , A.DURATION_TYPE , A.ENTRY_DT , A.EXPIRATN_DT , A.ISSUING_AUTHORITY , A.AUDIT_ACTN FROM PS_SCC_VISA_STG 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 DEPENDENT_ID Character(2) VARCHAR2(2) NOT NULL Dependent ID
6 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
7 VISA_PERMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Visa/Permit Type
8 EFFDT Date(10) DATE NOT NULL Effective Date
9 VISA_WRKPMT_NBR Character(15) VARCHAR2(15) NOT NULL Visa/Permit Number
10 VISA_WRKPMT_STATUS Character(1) VARCHAR2(1) NOT NULL Visa/Permit Status
A=Applied For
C=Cancelled
G=Granted
N=Renewed
R=Renewal in Progress
11 STATUS_DT Date(10) DATE NOT NULL Status Date
12 DT_ISSUED Date(10) DATE Issue Date
13 PLACE_ISSUED Character(30) VARCHAR2(30) NOT NULL Place of Issue
14 DURATION_TIME Number(6,1) DECIMAL(5,1) NOT NULL Duration Time
15 DURATION_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Duration
D=Days
M=Months
Y=Years
16 ENTRY_DT Date(10) DATE This field pertains to the date a person enters a country on a specific visa.
17 EXPIRATN_DT Date(10) DATE Expiration Date
18 ISSUING_AUTHORITY Character(50) VARCHAR2(50) NOT NULL Issuing Authority
19 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