[Home] [Help] [Dependency Information]
Object Name: | IGF_SE_PAYMENT_INT |
---|---|
Object Type: | TABLE |
Owner: | IGF |
FND Design Data: | IGF.IGF_SE_PAYMENT_INT |
Subobject Name: | |
Status: | VALID |
This entity is an Interface table that stores the payment details. The external HRMS system will upload data in this table. Later FA process will pick data from this table and upload it into IGF_SE_PAYMENT table.
Scope: public
Product: IGF
Lifecycle: active
Display Name: Student Employment - Upload Payroll Information
Category: BUSINESS_ENTITY IGF_FWS
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGF_SE_PAYMENT_INT_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE | TRANSACTION_ID |
IGF_SE_PAYMENT_INT_U2 | NORMAL | UNIQUE | APPS_TS_INTERFACE |
PAYROLL_ID
AUTH_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | (15) | Yes | Unique Identifier for every record |
BATCH_ID | NUMBER | (15) | Yes | Unique identifier for each payroll record. |
PAYROLL_ID | NUMBER | Yes | Unique identifier for each payroll record. | |
PAYROLL_DATE | DATE | Yes | Run date for the payroll record or if the record is entered manually, this will be the paid date. | |
AUTH_ID | NUMBER | (15) | Yes | Authorization Identifier for which the payment was made. |
PERSON_ID | NUMBER | (15) | Yes | Unique Person Identifier |
FUND_ID | NUMBER | (15) | Yes | Unique Fund Identifier for the fund from which the payment was made. |
LD_CAL_TYPE | VARCHAR2 | (10) | No longer used. | |
LD_SEQUENCE_NUMBER | NUMBER | (6) | No longer used. | |
PAID_AMOUNT | NUMBER | (15) | Yes | Amount paid from the fund to the student in lieu of his work study |
HRS_WORKED | NUMBER | (6) | No longer used. | |
ORG_UNIT_CD | VARCHAR2 | (360) | Name of the Organization that paid the Amount. This is not a placeholder for Organization Unit Code. | |
STATUS | VARCHAR2 | (10) | Yes | Indicates the status of the record. NEW for records that are newly entered in the table. DONE for records that have been uploaded to IGF_SE_PAYMENT. Once the record has been uploaded, it will be deleted.ERROR if there was any error while migrating. |
ERROR_CODE | VARCHAR2 | (10) | Error code incase error occurred while uploading. All the erroc code will correspond to lookup codes for Lookup Type of IGF_STUD_EMP_ERROR. | |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
CREATION_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_ID
, BATCH_ID
, PAYROLL_ID
, PAYROLL_DATE
, AUTH_ID
, PERSON_ID
, FUND_ID
, LD_CAL_TYPE
, LD_SEQUENCE_NUMBER
, PAID_AMOUNT
, HRS_WORKED
, ORG_UNIT_CD
, STATUS
, ERROR_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGF.IGF_SE_PAYMENT_INT;
IGF.IGF_SE_PAYMENT_INT does not reference any database object
IGF.IGF_SE_PAYMENT_INT is referenced by following:
|
|
|