SAD_UC_COFABB

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Prompt Table: INSTITUTION_TBL

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
Y/N Table Edit

7 SAD_UC_WITHDRAWAL Character(1) VARCHAR2(1) NOT NULL Withdrawal
Y/N Table Edit

8 SAD_UC_RELEASE Character(1) VARCHAR2(1) NOT NULL Release
Y/N Table Edit

9 SAD_UC_TARIFF Character(1) VARCHAR2(1) NOT NULL Tariff
Y/N Table Edit

10 SAD_UC_IMPORTED Character(1) VARCHAR2(1) NOT NULL Imported
Y/N Table Edit
Default Value: N

11 SAD_UC_ACTIVE_IND Character(1) VARCHAR2(1) NOT NULL Active
Y/N Table Edit
Default Value: Y

12 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 Prompt Table: INSTITUTION_TBL
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 Y/N Table Edit
7	SAD_UC_WITHDRAWAL	Character(1)	VARCHAR2(1) NOT NULL	Withdrawal Y/N Table Edit
8	SAD_UC_RELEASE	Character(1)	VARCHAR2(1) NOT NULL	Release Y/N Table Edit
9	SAD_UC_TARIFF	Character(1)	VARCHAR2(1) NOT NULL	Tariff Y/N Table Edit
10	SAD_UC_IMPORTED	Character(1)	VARCHAR2(1) NOT NULL	Imported Y/N Table Edit Default Value: N
11	SAD_UC_ACTIVE_IND	Character(1)	VARCHAR2(1) NOT NULL	Active Y/N Table Edit Default Value: Y
12	SAD_UC_TIMESTAMP	DateTime(26)	TIMESTAMP	Timestamp