INSTITUTIONDefault Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL
SFA_EQ_GROUP_TYPE0001=ACG 1
0002=ACG 2
0003=SMART 1
0004=SMART 2
0005=SMART 3
SFA_EQ_GROUP_NAMESFA_ASG_EQG_VW(SQL View) |
Index Back |
|---|---|
ACG/SMART Equation Group ViewDisplays the Equation Groups defined for an ACG 1, ACG 2, SMART 1, or SMART 2 grant. |
| SELECT A.INSTITUTION , A.SFA_EQ_GROUP_TYPE ,A.SFA_EQ_GROUP_NAME ,A.DESCR FROM PS_SFA_EQ_GROUP A |
| # | 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 | SFA_EQ_GROUP_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Group Type
0001=ACG 1 0002=ACG 2 0003=SMART 1 0004=SMART 2 0005=SMART 3 |
| 3 | SFA_EQ_GROUP_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Equation Group |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |