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_SE_PAYMENT_V

Product:	IGF - Financial Aid
Description:	The entity holds the payroll details that will be uploaded through a payment upload process. Data source for this will be the interface table .. User can also manually enter or update external payroll details.
Implementation/DBA Data:	APPS.IGF_SE_PAYMENT_V

View Text

SELECT SEP. ROWID ROW_ID
, SEP. TRANSACTION_ID
, SEP. PAYROLL_ID
, SEP. PAYROLL_DATE
, SEP. PERSON_ID
, SEP. FUND_ID
, SEP. AUTH_ID
, NULL
, NULL
, NULL
, NULL
, NULL
, SEP. PAID_AMOUNT
, NULL
, SEP. ORG_UNIT_CD
, SEP.SOURCE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SE_SOURCE'
, SEP.SOURCE) SOURCE_DESCRIPTION
, SEP. CREATED_BY
, SEP. CREATION_DATE
, SEP. LAST_UPDATED_BY
, SEP. LAST_UPDATE_DATE
, SEP. LAST_UPDATE_LOGIN
, SEP.REQUEST_ID
, SEP. PROGRAM_APPLICATION_ID
, SEP.PROGRAM_ID
, SEP. PROGRAM_UPDATE_DATE
FROM IGF_SE_PAYMENT SEP

Columns

Name
ROW_ID
TRANSACTION_ID
PAYROLL_ID
PAYROLL_DATE
PERSON_ID
FUND_ID
AUTH_ID
LD_CAL_TYPE
LD_SEQUENCE_NUMBER
LD_ALTERNATE_CODE
LD_START_DATE
LD_END_DATE
PAID_AMOUNT
HRS_WORKED
ORG_UNIT_CD
SOURCE
SOURCE_DESCRIPTION
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE