eTRM uses javascript that opens and focuses a separate window to display reports.
Your browser does not appear to support javascript. This should not prevent you from using
eTRM but it does mean the window focus feature will not work. Please check the contents of
other windows on your desktop if you click on a link that does not appear to do anything.
[Home] [Help]
View: IGF_AP_ATTEND_MAP
Product: IGF - Financial Aid (Obsolete)
Description: Stores the mapping from Attendance Types, which are user-defined in OSS to the Attendance Types(enrollment status of Pell Grants/FFELP Loans/Application Processing) which is used in Financial Aid
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT ATM.ROWID , ATM.ATM_ID , ATM.ATTENDANCE_TYPE , ATM.PELL_ATT_CODE , ATM.CL_ATT_CODE , ATM.AP_ATT_CODE , ATM.ORG_ID , ATM.CREATED_BY , ATM.CREATION_DATE , ATM.LAST_UPDATED_BY , ATM.LAST_UPDATE_DATE , ATM.LAST_UPDATE_LOGIN , ATM.CAL_TYPE , ATM.SEQUENCE_NUMBER FROM IGF_AP_ATTEND_MAP_ALL ATM WHERE NVL(ATM.ORG_ID , NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO') , 1 , 1) , ' ' , NULL , SUBSTRB(USERENV('CLIENT_INFO') , 1 , 10))) , -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO') , 1 , 1) , ' ' , NULL , SUBSTRB(USERENV('CLIENT_INFO') , 1 , 10))) , -99)
Columns
Name
ROW_ID
ATM_ID
ATTENDANCE_TYPE
PELL_ATT_CODE
CL_ATT_CODE
AP_ATT_CODE
ORG_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
CAL_TYPE
SEQUENCE_NUMBER