[Home] [Help] [Dependency Information]
Object Name: | IGFBV_STUDENT_PAYROLL_DETAILS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGF.IGFBV_STUDENT_PAYROLL_DETAILS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Base view for the entity that holds Student Payroll Details
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOAD_CALENDAR_TYPE | VARCHAR2 | (10) | Calendar Type for Load Calendar | |
LOAD_SEQUENCE_NUMBER | NUMBER | (6) | Unique Identifier for the Load Calendar | |
PAYROLL_DATE | DATE | Yes | Run date for the payroll record or if the record is entered manually, this will be the paid date. | |
HOURS_WORKED | VARCHAR2 | (0) | No longer used. | |
PAID_AMOUNT | NUMBER | Yes | Amount paid from the fund to the student in lieu of his work study | |
ORGANIZATIONAL_UNIT_CODE | VARCHAR2 | (360) | Organization Code that paid the amount | |
_LA:RECORD_SOURCE | CHAR | (54) | This is the record source. When the record is uploaded from the interface table the source is UPLOAD. When the record is manually entered in the MANUAL. When ever the record is manually updated the source is UPDATE | |
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. |
PAYROLL_ID | NUMBER | (15) | Unique identifier for each payroll record. This is null for the records which are manually entered in the system through the Form Screen | |
AUTHORIZATION_ID | NUMBER | (15) | Yes | Authorization Identifier for which the payment was made. |
TRANSACTION_ID | NUMBER | (15) | Yes | Unique Identifier for the records in the table |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT LOAD_CALENDAR_TYPE
, LOAD_SEQUENCE_NUMBER
, PAYROLL_DATE
, HOURS_WORKED
, PAID_AMOUNT
, ORGANIZATIONAL_UNIT_CODE
, _LA:RECORD_SOURCE
, PERSON_ID
, FUND_ID
, PAYROLL_ID
, AUTHORIZATION_ID
, TRANSACTION_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGFBV_STUDENT_PAYROLL_DETAILS;
APPS.IGFBV_STUDENT_PAYROLL_DETAILS is not referenced by any database object
|
|
|