ADM_APP_NBR_VW (SQL View)	Index Back
Adm Appl Nbr View This view is used as prompt/edit table for application numbers when entering application numbers directly without the addtional keys of ADM_APPL_DATA. It is used as for Admission Action Entry processing on the Admission Action Entry panel.

ADM_APP_NBR_VW

(SQL View)

Adm Appl Nbr View

This view is used as prompt/edit table for application numbers when entering application numbers directly without the addtional keys of ADM_APPL_DATA. It is used as for Admission Action Entry processing on the Admission Action Entry panel.

SELECT A.ADM_APPL_NBR ,A.EMPLID ,B.NAME ,A.ADMIT_TYPE ,A.ADM_APPL_CTR FROM PS_ADM_APPL_DATA A ,PS_SCC_PRI_NAME_VW B WHERE A.EMPLID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PEOPLE_SRCH

3 NAME Character(50) VARCHAR2(50) NOT NULL Name

4 ADMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Admit Type
Prompt Table: ADMIT_TYPE_TBL

5 ADM_APPL_CTR Character(4) VARCHAR2(4) NOT NULL Application Center

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ADM_APPL_NBR	Character(8)	VARCHAR2(8) NOT NULL	Application Nbr
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
4	ADMIT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Admit Type Prompt Table: ADMIT_TYPE_TBL
5	ADM_APPL_CTR	Character(4)	VARCHAR2(4) NOT NULL	Application Center