SAD_UC_OFABB_VW

(SQL View)

SELECT institution , sad_uc_abbrevcode , sad_uc_abbrevtext , sad_uc_uncond , sad_uc_withdrawal ,sad_uc_letterfrmat FROM PS_SAD_UC_COFABB WHERE sad_uc_active_ind = 'Y' UNION SELECT institution , sad_uc_abbrevid , sad_uc_abbrevtext ,'Y' ,'Y' ,'A' sad_uc_letterfrmat FROM ps_sad_uc_uofabb WHERE sad_uc_active_ind = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

2 SAD_UC_ABBREVCODE Character(2) VARCHAR2(2) NOT NULL Abbreviation Code

3 SAD_UC_ABBREVTEXT Character(250) VARCHAR2(250) NOT NULL Description

4 SAD_UC_UNCOND Character(1) VARCHAR2(1) NOT NULL Unconditional Offer

5 SAD_UC_WITHDRAWAL Character(1) VARCHAR2(1) NOT NULL Withdrawal

6 SAD_UC_LETTERFRMAT Character(1) VARCHAR2(1) NOT NULL Letter Format
A=No Indentation, Blank lines
B=Start at Column 3, Blank lines
C=Start at Column 5, Blank lines
D=Start at Col 5, No Blank lines
E=Start at Col 10,No Blank lines
F=No Indentation, No Blank lines
G=Start at Col 10, No Blank line

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
2	SAD_UC_ABBREVCODE	Character(2)	VARCHAR2(2) NOT NULL	Abbreviation Code
3	SAD_UC_ABBREVTEXT	Character(250)	VARCHAR2(250) NOT NULL	Description
4	SAD_UC_UNCOND	Character(1)	VARCHAR2(1) NOT NULL	Unconditional Offer
5	SAD_UC_WITHDRAWAL	Character(1)	VARCHAR2(1) NOT NULL	Withdrawal
6	SAD_UC_LETTERFRMAT	Character(1)	VARCHAR2(1) NOT NULL	Letter Format A=No Indentation, Blank lines B=Start at Column 3, Blank lines C=Start at Column 5, Blank lines D=Start at Col 5, No Blank lines E=Start at Col 10,No Blank lines F=No Indentation, No Blank lines G=Start at Col 10, No Blank line