[Home] [Help] [Dependency Information]
Object Name: | PER_HU_EMPLOYMENT_CERT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PER.PER_HU_EMPLOYMENT_CERT_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
View is used in Employment Certificate Web ADI Report.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PAYROLL_ACTION_ID | NUMBER | (9) | Yes | System generated primary key. |
REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
ASSIGNMENT_ACTION_ID | NUMBER | (15) | Yes | The system generated primary key. |
ORGANIZATION_ID | VARCHAR2 | (240) | System generated primary key. | |
EMPLOYER_LOCATION_NAME | VARCHAR2 | (240) | Employer Location Name | |
EMPLOYER_LOCATION_TYPE | VARCHAR2 | (240) | Employer Location Type | |
EMPLOYER_STREET_NO | VARCHAR2 | (240) | Employer Street Number | |
EMPLOYER_TOWN | VARCHAR2 | (240) | Employer Town | |
EMPLOYER_COUNTY | VARCHAR2 | (240) | Employer County | |
EMPLOYER_POSTAL_CODE | VARCHAR2 | (240) | Employer Postal Code | |
EMPLOYER_BUILDING | VARCHAR2 | (240) | ok fine. | |
EMPLOYER_STAIRWAY | VARCHAR2 | (240) | Employer Stairway | |
EMPLOYER_FLOOR | VARCHAR2 | (240) | Employer Floor | |
EMPLOYER_DOOR | VARCHAR2 | (240) | Employer Door | |
PERSON_ID | VARCHAR2 | (240) | System generated primary key. | |
COMPANY_NAME | VARCHAR2 | (240) | Company Name | |
FULL_NAME | VARCHAR2 | (240) | Full Name | |
MAIDEN_NAME | VARCHAR2 | (240) | Maidan Name | |
TAJ_CODE | VARCHAR2 | (240) | TAJ Code | |
PLACE_OF_BIRTH | VARCHAR2 | (240) | Place of Birth | |
DATE_OF_BIRTH | VARCHAR2 | (240) | Date of Birth | |
MOTHER_MAIDEN_NAME | VARCHAR2 | (240) | Mother Maiden Name | |
HIRE_DATE | VARCHAR2 | (240) | Hire Date | |
TERMINATION_DATE | VARCHAR2 | (240) | Termination Date | |
SICKNESS_HOLIDAY | VARCHAR2 | (240) | Sickness Holiday | |
RAILWAY_BENEFIT | VARCHAR2 | (240) | Railway Benefit | |
PENSION_FUND_DATE_OF_ENTRANCE | VARCHAR2 | (240) | Pension Fund Date of Entrance | |
PRIVATE_PENSION_FUND_CODE | VARCHAR2 | (240) | Private Pension Fund Code | |
PRIVATE_PENSION_FUND_NAME | VARCHAR2 | (240) | Private Pension Fund Name | |
PRIVATE_PENSION_FUND_ADDRESS | VARCHAR2 | (240) | Private Pension Fund Address | |
PRIVATE_PENSION_FUND_ACC_NO | VARCHAR2 | (240) | Private Pension Fund Account Number | |
VOLUNTARY_PENSION_FUND_NAME1 | VARCHAR2 | (240) | Voluntary Pension Fund Name1 | |
VOLUNTARY_PENSION_FUND_NAME2 | VARCHAR2 | (240) | Voluntary Pension Fund Name2 | |
VOLUNTARY_PENSION_FUND_NAME3 | VARCHAR2 | (240) | Voluntary Pension Fund Name3 | |
VOLUNTARY_PENSION_FUND_NAME4 | VARCHAR2 | (240) | Voluntary Pension Fund Name4 | |
VOLUNTARY_PENSION_FUND_NAME5 | VARCHAR2 | (240) | Voluntary Pension Fund Name5 | |
ISSUE_DATE | VARCHAR2 | (240) | Issue Date | |
EMPLOYEE_LOCATION_NAME | VARCHAR2 | (240) | Employee Location Name | |
EMPLOYEE_LOCATION_TYPE | VARCHAR2 | (240) | Employee Location Type | |
EMPLOYEE_STREET_NO | VARCHAR2 | (240) | Employee Street No | |
EMPLOYEE_TOWN | VARCHAR2 | (240) | Employee Town | |
EMPLOYEE_POSTAL_CODE | VARCHAR2 | (240) | Employee Postal Code | |
EMPLOYEE_BUILDING | VARCHAR2 | (240) | Employee Building | |
EMPLOYEE_STAIRWAY | VARCHAR2 | (240) | Employee Stairway | |
EMPLOYEE_FLOOR | VARCHAR2 | (240) | Employee Stairway | |
EMPLOYEE_DOOR | VARCHAR2 | (240) | Employee Door | |
SETTLEMENT_PAID | CHAR | (1) | Settlement Paid |
Cut, paste (and edit) the following text to query this object:
SELECT PAYROLL_ACTION_ID
, REQUEST_ID
, ASSIGNMENT_ACTION_ID
, ORGANIZATION_ID
, EMPLOYER_LOCATION_NAME
, EMPLOYER_LOCATION_TYPE
, EMPLOYER_STREET_NO
, EMPLOYER_TOWN
, EMPLOYER_COUNTY
, EMPLOYER_POSTAL_CODE
, EMPLOYER_BUILDING
, EMPLOYER_STAIRWAY
, EMPLOYER_FLOOR
, EMPLOYER_DOOR
, PERSON_ID
, COMPANY_NAME
, FULL_NAME
, MAIDEN_NAME
, TAJ_CODE
, PLACE_OF_BIRTH
, DATE_OF_BIRTH
, MOTHER_MAIDEN_NAME
, HIRE_DATE
, TERMINATION_DATE
, SICKNESS_HOLIDAY
, RAILWAY_BENEFIT
, PENSION_FUND_DATE_OF_ENTRANCE
, PRIVATE_PENSION_FUND_CODE
, PRIVATE_PENSION_FUND_NAME
, PRIVATE_PENSION_FUND_ADDRESS
, PRIVATE_PENSION_FUND_ACC_NO
, VOLUNTARY_PENSION_FUND_NAME1
, VOLUNTARY_PENSION_FUND_NAME2
, VOLUNTARY_PENSION_FUND_NAME3
, VOLUNTARY_PENSION_FUND_NAME4
, VOLUNTARY_PENSION_FUND_NAME5
, ISSUE_DATE
, EMPLOYEE_LOCATION_NAME
, EMPLOYEE_LOCATION_TYPE
, EMPLOYEE_STREET_NO
, EMPLOYEE_TOWN
, EMPLOYEE_POSTAL_CODE
, EMPLOYEE_BUILDING
, EMPLOYEE_STAIRWAY
, EMPLOYEE_FLOOR
, EMPLOYEE_DOOR
, SETTLEMENT_PAID
FROM APPS.PER_HU_EMPLOYMENT_CERT_V;
|
|
|