RESOURCE_ID

NULLABLE

NUMBER

RESOURCE_ID derived from PPM's RSC_RESOURCES table

USER_NAME

NULLABLE

VARCHAR2(200)

USER_NAME is the resource's username that is derived from KNTA_USERS table

FIRST_NAME

NULLABLE

VARCHAR2(80)

FIRST_NAME is the resource's first name that is derived from KNTA_USERS table

LAST_NAME

NULLABLE

VARCHAR2(80)

LAST_NAME is the resource's last name that is derived from KNTA_USERS table

EMAIL_ADDRESS

NULLABLE

VARCHAR2(80)

EMAIL_ADDRESS is the resource's email address that is derived from KNTA_USERS table

PHONE_NUMBER

NULLABLE

VARCHAR2(30)

PHONE_NUMBER is the resource's phone number that is derived from KNTA_USERS table

LOCATION_CODE

NULLABLE

VARCHAR2(150)

LOCATION_CODE contains the meaning of resource's location from knta_lookups

RESOURCE_CATEGORY

NULLABLE

VARCHAR2(150)

RESOURCE_CATEGORY contains the meaning of resource's category from knta_lookups

DEPARTMENT

NULLABLE

VARCHAR2(150)

DEPARTMENT contains the meaning of resource's department from knta_lookups

COMPANY

NULLABLE

VARCHAR2(150)

COMPANY contains the meaning of resource's company from knta_lookups

TITLE

NULLABLE

VARCHAR2(150)

TITLE contains the meaning of resource's title from knta_lookups

ROLE_NAME

NULLABLE

VARCHAR2(260)

Resource's role name, denormalized.

PRIMARY_ROLE_ID

NULLABLE

NUMBER

Primary role ID of this resource. PPM just supports one role per resource in the application, although it says primary.

REGION_ID

NULLABLE

NUMBER

Region to which this resource is associated to

CALENDAR_NAME

NULLABLE

VARCHAR2(100)

Name of the regional calendar (the calendar that is associated to resource's region)

START_DATE

NULLABLE

DATE

Start date for the resource. This is a required field for any resource in the system.

END_DATE

NULLABLE

DATE

End date of a resource and this is not a required field.

MANAGER_ID

NULLABLE

NUMBER

USER_ID of the resource's direct manager

MANAGER_FIRST_NAME

NULLABLE

VARCHAR2(80)

Direct manager's first name

MANAGER_LAST_NAME

NULLABLE

VARCHAR2(80)

Direct manager's last name

LEVEL1_MANAGER_ID

NULLABLE

VARCHAR2(4000)

USER_ID of top level manager of this resource

LEVEL1_MANAGER_FIRST_NAME

NULLABLE

VARCHAR2(4000)

FIRST_NAME of top level manager of this resource

LEVEL1_MANAGER_LAST_NAME

NULLABLE

VARCHAR2(4000)

LAST_NAME of top level manager of this resource

LEVEL2_MANAGER_ID

NULLABLE

VARCHAR2(4000)

USER_ID of level 2 manager of this resource

LEVEL2_MANAGER_FIRST_NAME

NULLABLE

VARCHAR2(4000)

FIRST_NAME of level 2 manager of this resource

LEVEL2_MANAGER_LAST_NAME

NULLABLE

VARCHAR2(4000)

LAST_NAME of level 2 manager of this resource

LEVEL3_MANAGER_ID

NULLABLE

VARCHAR2(4000)

USER_ID of level 3 manager of this resource

LEVEL3_MANAGER_FIRST_NAME

NULLABLE

VARCHAR2(4000)

FIRST_NAME of level 3 manager of this resource

LEVEL3_MANAGER_LAST_NAME

NULLABLE

VARCHAR2(4000)

LAST_NAME of level 3 manager of this resource

LEVEL4_MANAGER_ID

NULLABLE

VARCHAR2(4000)

USER_ID of level 4 manager of this resource

LEVEL4_MANAGER_FIRST_NAME

NULLABLE

VARCHAR2(4000)

FIRST_NAME of level 4 manager of this resource

LEVEL4_MANAGER_LAST_NAME

NULLABLE

VARCHAR2(4000)

LAST_NAME of level 4 manager of this resource

LEVEL5_MANAGER_ID

NULLABLE

VARCHAR2(4000)

USER_ID of level 5 manager of this resource

LEVEL5_MANAGER_FIRST_NAME

NULLABLE

VARCHAR2(4000)

FIRST_NAME of level 5 manager of this resource

LEVEL5_MANAGER_LAST_NAME

NULLABLE

VARCHAR2(4000)

LAST_NAME of level 5 manager of this resource

LEVEL6_MANAGER_ID

NULLABLE

VARCHAR2(4000)

USER_ID of level 6 manager of this resource

LEVEL6_MANAGER_FIRST_NAME

NULLABLE

VARCHAR2(4000)

FIRST_NAME of level 6 manager of this resource

LEVEL6_MANAGER_LAST_NAME

NULLABLE

VARCHAR2(4000)

LAST_NAME of level 6 manager of this resource

LEVEL7_MANAGER_ID

NULLABLE

VARCHAR2(4000)

USER_ID of level 7 manager of this resource

LEVEL7_MANAGER_FIRST_NAME

NULLABLE

VARCHAR2(4000)

FIRST_NAME of level 7 manager of this resource

LEVEL7_MANAGER_LAST_NAME

NULLABLE

VARCHAR2(4000)

LAST_NAME of level 7 manager of this resource

LEVEL8_MANAGER_ID

NULLABLE

VARCHAR2(4000)

USER_ID of level 8 manager of this resource

LEVEL8_MANAGER_FIRST_NAME

NULLABLE

VARCHAR2(4000)

FIRST_NAME of level 8 manager of this resource

LEVEL8_MANAGER_LAST_NAME

NULLABLE

VARCHAR2(4000)

LAST_NAME of level 8 manager of this resource

LEVEL9_MANAGER_ID

NULLABLE

VARCHAR2(4000)

USER_ID of level 9 manager of this resource

LEVEL9_MANAGER_FIRST_NAME

NULLABLE

VARCHAR2(4000)

FIRST_NAME of level 9 manager of this resource

LEVEL9_MANAGER_LAST_NAME

NULLABLE

VARCHAR2(4000)

LAST_NAME of level 9 manager of this resource

LEVEL10_MANAGER_ID

NULLABLE

VARCHAR2(4000)

USER_ID of level 10 manager of this resource

LEVEL10_MANAGER_FIRST_NAME

NULLABLE

VARCHAR2(4000)

FIRST_NAME of level 10 manager of this resource

LEVEL10_MANAGER_LAST_NAME

NULLABLE

VARCHAR2(4000)

LAST_NAME of level 10 manager of this resource

PRIMARY_ORG_UNIT_ID

NULLABLE

NUMBER

Resource's primary org unit

NAMED_RESOURCE_FLAG

NULLABLE

VARCHAR2(1)

Flag to indicate if this resource is a named or unnamed resource

TM_APPROVER

NULLABLE

VARCHAR2(4000)

Username of this resource's time approver

TM_APPROVER_SEC_GRP

NULLABLE

VARCHAR2(4000)

The security group name who can approve the time sheet

TM_BILLING_APPROVER

NULLABLE

VARCHAR2(4000)

Username of this resource's billing approver

TM_BILLING_APPROVER_SEC_GRP

NULLABLE

VARCHAR2(4000)

The security group name for resource's billing approvals

USER_DATA1-20

NULLABLE

VARCHAR2(200)

User data segment

VISIBLE_USER_DATA1-20

NULLABLE

VARCHAR2(200)

User data segment