VISA_PMT_DAT_VW (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.

VISA_PMT_DAT_VW

(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.

SELECT DISTINCT EMPLID , DEPENDENT_ID , COUNTRY , VISA_PERMIT_TYPE FROM PS_VISA_PMT_DATA A WHERE DEPENDENT_ID = ' ' AND EFFDT = ( SELECT MAX(EFFDT) FROM PS_VISA_PMT_DATA B WHERE A.EMPLID = B.EMPLID AND A.DEPENDENT_ID = B.DEPENDENT_ID AND A.COUNTRY = B.COUNTRY AND A.VISA_PERMIT_TYPE = B.VISA_PERMIT_TYPE)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 DEPENDENT_ID Character(2) VARCHAR2(2) NOT NULL Dependent ID
Prompt Table: DEPENDENT_VW

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: VISA_PERMIT_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	DEPENDENT_ID	Character(2)	VARCHAR2(2) NOT NULL	Dependent ID Prompt Table: DEPENDENT_VW
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: VISA_PERMIT_TBL