VISA_PERMIT_SUP (SQL Table)	Index Back
Visa Supporting Docs Needed Use VISA_PERMIT_SUP to specify supporting documents required for a visa or permit identified on VISA_PERMIT_TBL. Use VISA_PERMIT_TBL to track visa or permit requirements for each country where your company's employees live or work.

VISA_PERMIT_SUP

(SQL Table)

Visa Supporting Docs Needed

Use VISA_PERMIT_SUP to specify supporting documents required for a visa or permit identified on VISA_PERMIT_TBL. Use VISA_PERMIT_TBL to track visa or permit requirements for each country where your company's employees live or work.

Parent record: VISA_PERMIT_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 VISA_PERMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Visa/Permit Type
Prompt Table: VISA_PERMIT_TBL

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

4 SUPPORT_DOC_ID Character(6) VARCHAR2(6) NOT NULL Supporting Document ID
Prompt Table: SUPPORT_DOC_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
2	VISA_PERMIT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Visa/Permit Type Prompt Table: VISA_PERMIT_TBL
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	SUPPORT_DOC_ID	Character(6)	VARCHAR2(6) NOT NULL	Supporting Document ID Prompt Table: SUPPORT_DOC_TBL