TL_TSKPRF_DETL

(SQL Table)
 Index Back

Time Task Profile Detail

This record defines the detail portion of the Task Profile. This breaks out the allocation amounts and the specific values for the accounting transaction for which it applies within Time & Labor.

  • Parent record: TL_TSKPRF

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TASK_PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Task Profile ID
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 TSKPRF_SEQNUM Number(3,0) SMALLINT NOT NULL Task Profile Detail Seq Nbr
    4 ALLOCATION_AMT Signed Number(13,6) DECIMAL(11,6) NOT NULL Allocation Amount
    5 ALLOCATION_PCT Number(8,6) DECIMAL(7,6) NOT NULL Allocation Factor
    6 ALLOCATION_ACC Number(8,6) DECIMAL(7,6) NOT NULL Allocation Accum
    7 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: TL_BUS_UNIT_VW

    9 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID
    10 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: TL_LOCATION_VW

    11 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
    12 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: TL_DEPT_TBL_VW

    13 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID
    14 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: TL_JOBCODE_VW

    15 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Prompt Table: POSITION_DATA

    16 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product

    Prompt Table: TL_PRODUCT_TBL

    17 CUSTOMER Character(10) VARCHAR2(10) NOT NULL Customer

    Prompt Table: TL_CUSTOMER

    18 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code

    Prompt Table: TL_ACCTCD_BU_VW

    19 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL Project Costing Business Unit

    Prompt Table: BUS_UNIT_PRJ_VW

    20 BUSINESS_UNIT_PF Character(5) VARCHAR2(5) NOT NULL Perf Meas Business Unit

    Prompt Table: BUS_UNIT_TBL_PF

    21 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project/Grant

    Prompt Table: %EDIT_PROJECT

    22 SETID_ACTIVITY Character(5) VARCHAR2(5) NOT NULL Activity Set ID
    23 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

    Prompt Table: %EDIT_ACTIVITY

    24 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Project Costing Resource Type

    Prompt Table: TL_PROJ_RTYPE_V

    25 SETID_RESOURCE Character(5) VARCHAR2(5) NOT NULL Resource Set ID
    26 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Project Costing Resource Category

    Prompt Table: %EDIT_RES_CAT

    27 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Project Costing Resource Sub Category

    Prompt Table: %EDIT_RES_SUB

    28 TASK Character(5) VARCHAR2(5) NOT NULL Task

    Prompt Table: TL_TASK

    29 USER_FIELD_1 Character(10) VARCHAR2(10) NOT NULL User Field 1

    Prompt Table: TL_USER_FIELD_1

    30 USER_FIELD_2 Character(10) VARCHAR2(10) NOT NULL User Field 2

    Prompt Table: TL_USER_FIELD_2

    31 USER_FIELD_3 Character(15) VARCHAR2(15) NOT NULL User Field 3

    Prompt Table: TL_USER_FIELD_3

    32 USER_FIELD_4 Character(20) VARCHAR2(20) NOT NULL User Field 4

    Prompt Table: TL_USER_FIELD_4

    33 USER_FIELD_5 Character(20) VARCHAR2(20) NOT NULL User Field 5

    Prompt Table: TL_USER_FIELD_5