SCC_VISA_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	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