SCC_VISA_SUP_H (SQL View)	Index Back
EE/Depndnt Visa Support Docs Use VISA_PMT_SUPPRT to identify documents presented in support of each visa or permit recorded on VISA_PMT_DATA for an employee or dependent. Campus Solutions hollow view for the core VISA_PMT_SUPPRT table. Data is actually sourced from the Service Oriented Architecture.

SCC_VISA_SUP_H

(SQL View)

EE/Depndnt Visa Support Docs

Use VISA_PMT_SUPPRT to identify documents presented in support of each visa or permit recorded on VISA_PMT_DATA for an employee or dependent. Campus Solutions hollow view for the core VISA_PMT_SUPPRT table. Data is actually sourced from the Service Oriented Architecture.

SELECT ' ' , ' ' , ' ' , ' ' , %DateNull , ' ' , %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 SUPPORT_DOC_ID Character(6) VARCHAR2(6) NOT NULL Supporting Document ID
Prompt Table: HCR_SUPPR_DOC_I

7 REQUEST_DT Date(10) DATE Request Date

8 DT_RECVD Date(10) DATE Date Received

#	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	SUPPORT_DOC_ID	Character(6)	VARCHAR2(6) NOT NULL	Supporting Document ID Prompt Table: HCR_SUPPR_DOC_I
7	REQUEST_DT	Date(10)	DATE	Request Date
8	DT_RECVD	Date(10)	DATE	Date Received