[Home] [Help]
View: IGF_AW_COA_GROUP_V
| Product: | IGF - Financial Aid (Obsolete) |
|---|
| Description: | Stores group codes for cost of attendance |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT COAG.ROW_ID
, COAG.COA_CODE
, NULL
, COAG.CI_CAL_TYPE
, COAG.CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, COAG.CREATED_BY
, COAG.CREATION_DATE
, COAG.LAST_UPDATE_DATE
, COAG.LAST_UPDATED_BY
, COAG.LAST_UPDATE_LOGIN
, COAG.COA_GRP_DESC
FROM IGF_AW_COA_GROUP COAG
, IGS_CA_INST CI
WHERE COAG.CI_CAL_TYPE = CI.CAL_TYPE
AND COAG.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
Columns
| Name |
| ROW_ID |
| COA_CODE |
| DESCRIPTION |
| CI_CAL_TYPE |
| CI_SEQUENCE_NUMBER |
| CI_ALTERNATE_CODE |
| CI_START_DT |
| CI_END_DT |
| RULE_ORDER |
| S_RULE_CALL_CD |
| RUL_SEQUENCE_NUMBER |
| RUD_SEQUENCE_NUMBER |
| S_RETURN_TYPE |
| RULE_DESCRIPTION |
| RULE_TEXT |
| RUG_SEQUENCE_NUMBER |
| PELL_COA |
| PELL_ALT_EXP |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_LOGIN |
| COA_GRP_DESC |