SAD_LISTVAL_VW (SQL View)	Index Back
Admissions OLA LOV Prompts Contains fields used for prompting via the SCC_LOV service

SAD_LISTVAL_VW

(SQL View)

Admissions OLA LOV Prompts

Contains fields used for prompting via the SCC_LOV service

SELECT 'Y' , 'Y' , 'Y' , ' ' FROM PS_INSTALLATION_SA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SAD_APP_FEE_REQ Character(1) VARCHAR2(1) NOT NULL AAWS Application Fee Waiver processing switch to define whether application fees are required or not.
N=No
Y=Yes
Prompt Table: ADM_APPLCTR_TBL

2 SAD_APP_FEE_WHEN Character(1) VARCHAR2(1) NOT NULL AAWS Application Fee Waiver processing switch to define when the payment fee is required.
L=Pay Later
S=At Application Submission
Prompt Table: ADM_APPLCTR_TBL

3 SAD_APP_FEE_ALOWVR Character(1) VARCHAR2(1) NOT NULL AAWS Application Fee Waiver processing switch to allow fee waivers.
N=No
Y=Yes
Prompt Table: ADM_APPLCTR_TBL

4 SAD_WAIVER_BASIS Character(6) VARCHAR2(6) NOT NULL Fee Waiver Basis Code.
Prompt Table: SAD_WVRBASCDVW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SAD_APP_FEE_REQ	Character(1)	VARCHAR2(1) NOT NULL	AAWS Application Fee Waiver processing switch to define whether application fees are required or not. N=No Y=Yes Prompt Table: ADM_APPLCTR_TBL
2	SAD_APP_FEE_WHEN	Character(1)	VARCHAR2(1) NOT NULL	AAWS Application Fee Waiver processing switch to define when the payment fee is required. L=Pay Later S=At Application Submission Prompt Table: ADM_APPLCTR_TBL
3	SAD_APP_FEE_ALOWVR	Character(1)	VARCHAR2(1) NOT NULL	AAWS Application Fee Waiver processing switch to allow fee waivers. N=No Y=Yes Prompt Table: ADM_APPLCTR_TBL
4	SAD_WAIVER_BASIS	Character(6)	VARCHAR2(6) NOT NULL	Fee Waiver Basis Code. Prompt Table: SAD_WVRBASCDVW