RS_TASK_TYPE

(SQL Table)
Index Back

Task Category

  • Related Language Record: RS_TASK_TYPE_LN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TASK_TYPE Character(18) VARCHAR2(18) NOT NULL Task Category
    2 SYSTEM_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.

    Default Value: RS

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 FLEXIBILITY Number(4,2) DECIMAL(3,2) NOT NULL Flexibility Factor
    5 RESV_FLEXIBILITY Number(4,2) DECIMAL(3,2) NOT NULL Reserved Status Flexibility
    6 RS_ASSIGNMENT_FLAG Character(1) VARCHAR2(1) NOT NULL Use for Assignment

    Y/N Table Edit

    Default Value: N

    7 RS_MANAGER Character(1) VARCHAR2(1) NOT NULL Update by Manager
    N=N
    Y=Y

    Y/N Table Edit

    Default Value: Y

    8 RS_RESOURCE Character(1) VARCHAR2(1) NOT NULL Update by Resource

    Y/N Table Edit

    Default Value: Y

    9 RS_MGR_NOTIFY Character(1) VARCHAR2(1) NOT NULL Notify by Manager

    Y/N Table Edit

    Default Value: N

    10 RS_RES_NOTIFY Character(1) VARCHAR2(1) NOT NULL Notify by Resource

    Y/N Table Edit

    Default Value: N

    11 RS_TYPE_SYS_OPT Character(1) VARCHAR2(1) NOT NULL System Delivered
    O=Other
    S=System

    Default Value: O

    12 EXTERNAL_CATEGORY Character(40) VARCHAR2(40) NOT NULL External Category
    13 DESCRLONG Long Character CLOB Long Description