SAD_UC_I_COFABB

(SQL Table)

# 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_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

5 SAD_UC_SUMMARYCHAR Character(1) VARCHAR2(1) NOT NULL Summary of Conditions

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

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

8 SAD_UC_RELEASE Character(1) VARCHAR2(1) NOT NULL Release

9 SAD_UC_TARIFF Character(1) VARCHAR2(1) NOT NULL Tariff

10 SAD_UC_TIMESTAMP DateTime(26) TIMESTAMP Timestamp

#	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_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
5	SAD_UC_SUMMARYCHAR	Character(1)	VARCHAR2(1) NOT NULL	Summary of Conditions
6	SAD_UC_UNCOND	Character(1)	VARCHAR2(1) NOT NULL	Unconditional Offer
7	SAD_UC_WITHDRAWAL	Character(1)	VARCHAR2(1) NOT NULL	Withdrawal
8	SAD_UC_RELEASE	Character(1)	VARCHAR2(1) NOT NULL	Release
9	SAD_UC_TARIFF	Character(1)	VARCHAR2(1) NOT NULL	Tariff
10	SAD_UC_TIMESTAMP	DateTime(26)	TIMESTAMP	Timestamp