SCC_VISA_PMT_H (SQL View)	Index Back
EE/Dependent Visa Data Use VISA_PMT_DATA to record visas and permits held by an employee or dependent. Use a subordinate record, VISA_PMT_SUPPRT, to identify documents presented in support of each visa or permit. Campus Solutions hollow view for the core VISA_PMT_DATA table. Data is actually sourced from the Service Oriented Architecture.

SCC_VISA_PMT_H

(SQL View)

EE/Dependent Visa Data

Use VISA_PMT_DATA to record visas and permits held by an employee or dependent. Use a subordinate record, VISA_PMT_SUPPRT, to identify documents presented in support of each visa or permit. Campus Solutions hollow view for the core VISA_PMT_DATA table. Data is actually sourced from the Service Oriented Architecture.

SELECT ' ' , ' ' , ' ' , ' ' , %DateNull , ' ' , ' ' , %DateNull , %DateNull , ' ' , 0 , ' ' , %DateNull , %DateNull , ' ' FROM %Table(INSTALLATION_SA)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 DEPENDENT_ID Character(2) VARCHAR2(2) NOT NULL Dependent ID

3 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

4 VISA_PERMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Visa/Permit Type
Prompt Table: HCR_VISA_PERM_I

5 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

6 VISA_WRKPMT_NBR Character(15) VARCHAR2(15) NOT NULL Visa/Permit Number

7 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
Default Value: A

8 STATUS_DT Date(10) DATE NOT NULL Status Date
Default Value: %date

9 DT_ISSUED Date(10) DATE Issue Date

10 PLACE_ISSUED Character(30) VARCHAR2(30) NOT NULL Place of Issue

11 DURATION_TIME Number(6,1) DECIMAL(5,1) NOT NULL Duration Time

12 DURATION_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Duration
D=Days
M=Months
Y=Years
Default Value: M

13 ENTRY_DT Date(10) DATE This field pertains to the date a person enters a country on a specific visa.

14 EXPIRATN_DT Date(10) DATE Expiration Date

15 ISSUING_AUTHORITY Character(50) VARCHAR2(50) NOT NULL Issuing Authority

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	DEPENDENT_ID	Character(2)	VARCHAR2(2) NOT NULL	Dependent ID
3	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
4	VISA_PERMIT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Visa/Permit Type Prompt Table: HCR_VISA_PERM_I
5	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
6	VISA_WRKPMT_NBR	Character(15)	VARCHAR2(15) NOT NULL	Visa/Permit Number
7	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 Default Value: A
8	STATUS_DT	Date(10)	DATE NOT NULL	Status Date Default Value: %date
9	DT_ISSUED	Date(10)	DATE	Issue Date
10	PLACE_ISSUED	Character(30)	VARCHAR2(30) NOT NULL	Place of Issue
11	DURATION_TIME	Number(6,1)	DECIMAL(5,1) NOT NULL	Duration Time
12	DURATION_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Type of Duration D=Days M=Months Y=Years Default Value: M
13	ENTRY_DT	Date(10)	DATE	This field pertains to the date a person enters a country on a specific visa.
14	EXPIRATN_DT	Date(10)	DATE	Expiration Date
15	ISSUING_AUTHORITY	Character(50)	VARCHAR2(50) NOT NULL	Issuing Authority