[Home] [Help] [Dependency Information]
Object Name: | IGFFV_STUDENT_PAYROLL_DETAILS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGF.IGFFV_STUDENT_PAYROLL_DETAILS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Full View for the Entity that holds Student Payroll Details
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PAYROLL_DATE | DATE | Yes | Run date for the payroll record or if the record is entered manually, this will be the paid date. | |
LOAD_CALENDAR_TYPE | VARCHAR2 | (10) | Calendar Type for Load Calendar | |
LOAD_SEQUENCE_NUMBER | NUMBER | (6) | Unique Identifier for the Load Calendar | |
HOURS_WORKED | NUMBER | (6) | Hours worked this payroll period | |
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_NUMBER | VARCHAR2 | (30) | Yes | Person Number |
FIRST_NAME | VARCHAR2 | (150) | Person First Name | |
LAST_NAME | VARCHAR2 | (150) | Person Last Name | |
MIDDLE_NAME | VARCHAR2 | (60) | Person Middle Name | |
FUND_CODE | VARCHAR2 | (30) | Yes | Fund Code |
AWARD_YEAR | VARCHAR2 | (10) | Awarding Year | |
LOAD_CALENDAR | VARCHAR2 | (10) | Load Calendar | |
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 that 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 PAYROLL_DATE
, LOAD_CALENDAR_TYPE
, LOAD_SEQUENCE_NUMBER
, HOURS_WORKED
, PAID_AMOUNT
, ORGANIZATIONAL_UNIT_CODE
, _LA:RECORD_SOURCE
, PERSON_NUMBER
, FIRST_NAME
, LAST_NAME
, MIDDLE_NAME
, FUND_CODE
, AWARD_YEAR
, LOAD_CALENDAR
, PERSON_ID
, FUND_ID
, PAYROLL_ID
, AUTHORIZATION_ID
, TRANSACTION_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGFFV_STUDENT_PAYROLL_DETAILS;
APPS.IGFFV_STUDENT_PAYROLL_DETAILS is not referenced by any database object
|
|
|