SFA_ASG_SETUP(SQL Table) |
Index Back |
|---|---|
ACG/SMART Setup TableACG/SMART Setup Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 2 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR Prompt Table: AID_YEAR_TBL |
| 3 | TIV_SCHOOL_CODE |
Character(6) | VARCHAR2(6) NOT NULL |
Pell ID Reporting
Prompt Table: INST_SCHOOL_CDS |
| 4 | SFA_ASG_ORIG_OFFER | Character(1) | VARCHAR2(1) NOT NULL |
Originate Offered Awards
Y/N Table Edit Default Value: N |
| 5 | SFA_ASG_DSB_OFFSET | Signed Number(3,0) | DECIMAL(2) NOT NULL | Disbursement Offset |
| 6 | SFA_ASG_DSB_PR_XMT | Character(1) | VARCHAR2(1) NOT NULL |
Disb Prior to Transmitting
Y/N Table Edit Default Value: N |