[Home] [Help] [Dependency Information]
Object Name: | PAY_JP_WL_EMPLOYEE_DETAILS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAY_JP_WL_EMPLOYEE_DETAILS_V |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
ACTION_INFORMATION_ID | NUMBER | (15) | Yes | |
OBJECT_VERSION_NUMBER | NUMBER | |||
ASSIGNMENT_ACTION_ID | NUMBER | (15) | Yes | |
ACTION_CONTEXT_TYPE | VARCHAR2 | (15) | Yes | |
ASSIGNMENT_ID | NUMBER | (10) | ||
EFFECTIVE_DATE | DATE | |||
ACTION_INFORMATION_CATEGORY | VARCHAR2 | (80) | Yes | |
ORGANIZATION_ID | NUMBER | |||
PAYROLL_ID | NUMBER | |||
WITHHOLDING_AGENT_ID | NUMBER | |||
LOCATION_ID | NUMBER | |||
PERSON_ID | NUMBER | |||
FULL_NAME_KANA | VARCHAR2 | (240) | ||
FULL_NAME_KANJI | VARCHAR2 | (240) | ||
PAYROLL_NAME | VARCHAR2 | (240) | ||
AGE | NUMBER | |||
HEALTH_INSURANCE_NUMBER | VARCHAR2 | (240) | ||
WELFARE_PENSION_INS_NUMBER | VARCHAR2 | (240) | ||
BASIC_PENSION_NUMBER | VARCHAR2 | (240) | ||
UNEMPLOYMENT_INSURANCE_NUMBER | VARCHAR2 | (240) | ||
HIRE_DATE | DATE | |||
YEARS_OF_SERVICE | NUMBER | |||
TAX_CLASS | VARCHAR2 | (240) | ||
TERMINATION_DATE | DATE | |||
ORGANIZATION_NAME | VARCHAR2 | (240) | ||
GENDER | VARCHAR2 | (240) | ||
JOB_NAME | VARCHAR2 | (240) | ||
POSTAL_CODE | VARCHAR2 | (240) | ||
ADDRESS_LINE1 | VARCHAR2 | (240) | ||
ADDRESS_LINE2 | VARCHAR2 | (240) | ||
ADDRESS_LINE3 | VARCHAR2 | (240) | ||
DATE_OF_BIRTH | DATE | |||
EMPLOYEE_NUMBER | VARCHAR2 | (240) | ||
PHONE | VARCHAR2 | (240) | ||
ADDRESS_LINE1_KANA | VARCHAR2 | (240) | ||
ADDRESS_LINE2_KANA | VARCHAR2 | (240) | ||
ADDRESS_LINE3_KANA | VARCHAR2 | (240) | ||
LAST_UPDATE_LOGIN | NUMBER | |||
LAST_UPDATED_BY | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
CREATED_BY | NUMBER | |||
CREATION_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ACTION_INFORMATION_ID
, OBJECT_VERSION_NUMBER
, ASSIGNMENT_ACTION_ID
, ACTION_CONTEXT_TYPE
, ASSIGNMENT_ID
, EFFECTIVE_DATE
, ACTION_INFORMATION_CATEGORY
, ORGANIZATION_ID
, PAYROLL_ID
, WITHHOLDING_AGENT_ID
, LOCATION_ID
, PERSON_ID
, FULL_NAME_KANA
, FULL_NAME_KANJI
, PAYROLL_NAME
, AGE
, HEALTH_INSURANCE_NUMBER
, WELFARE_PENSION_INS_NUMBER
, BASIC_PENSION_NUMBER
, UNEMPLOYMENT_INSURANCE_NUMBER
, HIRE_DATE
, YEARS_OF_SERVICE
, TAX_CLASS
, TERMINATION_DATE
, ORGANIZATION_NAME
, GENDER
, JOB_NAME
, POSTAL_CODE
, ADDRESS_LINE1
, ADDRESS_LINE2
, ADDRESS_LINE3
, DATE_OF_BIRTH
, EMPLOYEE_NUMBER
, PHONE
, ADDRESS_LINE1_KANA
, ADDRESS_LINE2_KANA
, ADDRESS_LINE3_KANA
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
FROM APPS.PAY_JP_WL_EMPLOYEE_DETAILS_V;
APPS.PAY_JP_WL_EMPLOYEE_DETAILS_V is not referenced by any database object
|
|
|