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 SeqNum
    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 SetID
    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 SetID
    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 SetID
    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
    19 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
    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
    22 SETID_ACTIVITY Character(5) VARCHAR2(5) NOT NULL Activity SetID
    23 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    24 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Resource Type

    Prompt Table: TL_PROJ_RTYPE_V

    25 SETID_RESOURCE Character(5) VARCHAR2(5) NOT NULL Resource SetID
    26 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Resource Category
    27 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Resource Sub Category
    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