DBA Data[Home] [Help] [Dependency Information]

TABLE: ICX.POR_EMPLOYEE_LOADER_VALUES

Object Details
Object Name: POR_EMPLOYEE_LOADER_VALUES
Object Type: TABLE
Owner: ICX
FND Design Data: TableICX.POR_EMPLOYEE_LOADER_VALUES
Subobject Name:
Status: VALID


The table stores the employee information for an employee and is populated by the employee loader.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
POR_EMPLOYEE_LOADER_VALUES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnEMPLOYEE_NUMBER
Columns
Name Datatype Length Mandatory Comments
EMPLOYEE_NUMBER VARCHAR2 (30)
This is the employee number for the employee in the organization.
FIRST_NAME VARCHAR2 (30)
This is the first name of the employee
LAST_NAME VARCHAR2 (40)
This is the last name of the employee
MIDDLE_NAME VARCHAR2 (60)
This is the middle name of the employee
SEX VARCHAR2 (30)
This is the sex of the employee
START_DATE DATE

This is the start date of the employee in the organization
END_DATE DATE

This is the end date of the employee in the organization
BUSINESS_GROUP_NAME VARCHAR2 (240)
This is the name of the business group to which the employee belongs
LOCATION_CODE VARCHAR2 (30)
This is the location code associated with that employee
SET_OF_BOOKS VARCHAR2 (30)
This is the set of books associated with the organization, that the employee belongs to
DEFAULT_EXPENSE_ACCOUNT VARCHAR2 (50)
This is the default expense account for the employee
JOB_NAME VARCHAR2 (30)
This is the job name for the employee
SUPERVISOR_EMP_NUM VARCHAR2 (30)
This is the employee number of the employee's supervisor.
USER_NAME VARCHAR2 (30)
This is the employee's user name for the applications.
PASSWORD VARCHAR2 (30)
This is the employee's password name for the applications.
EMAIL_ADDRESS VARCHAR2 (30)
This is the employee's email address
WORK_TELEPHONE VARCHAR2 (30)
This is the work telephone number of the employee
LOADER_STATUS VARCHAR2 (30)
This indicates if this employee record was loaded correctly.
LAST_UPDATE_DATE DATE
Yes Date the record was last updated
LAST_UPDATE_LOGIN NUMBER (15)
The user name of the person who last updated it
LAST_UPDATED_BY NUMBER (15) Yes The person who last updated it
CREATION_DATE DATE
Yes The date the record was created
CREATED_BY NUMBER (15) Yes The person who created the record
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EMPLOYEE_NUMBER
,      FIRST_NAME
,      LAST_NAME
,      MIDDLE_NAME
,      SEX
,      START_DATE
,      END_DATE
,      BUSINESS_GROUP_NAME
,      LOCATION_CODE
,      SET_OF_BOOKS
,      DEFAULT_EXPENSE_ACCOUNT
,      JOB_NAME
,      SUPERVISOR_EMP_NUM
,      USER_NAME
,      PASSWORD
,      EMAIL_ADDRESS
,      WORK_TELEPHONE
,      LOADER_STATUS
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM ICX.POR_EMPLOYEE_LOADER_VALUES;

Dependencies

[top of page]

ICX.POR_EMPLOYEE_LOADER_VALUES does not reference any database object

ICX.POR_EMPLOYEE_LOADER_VALUES is referenced by following:

SchemaICX
ViewPOR_EMPLOYEE_LOADER_VALUES#