PTLT_TASKCMP_VW

index back

SELECT PTLT_TASK_CODE , PTLT_TASK_NAME , PTLT_TASK_TYPE , PTLT_LOAD_METHOD , PTLT_NODMS_FLAG , PTLT_CROSSDB_FLAG , NAVIGATION , DESCR254_MIXED , OBJECTOWNERID FROM %Table(PTLT_TASK) WHERE PTLT_TASK_TYPE = 'C'

  • Related language record: PTLT_CMPTASKLVW
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PTLT_TASK_CODECharacter(30)VARCHAR2(30) NOT NULLTask Code
    PTLT_TASK_NAMECharacter(30)VARCHAR2(30) NOT NULLTask Name
    PTLT_TASK_TYPECharacter(1)VARCHAR2(1) NOT NULLTask Type
    C=Component
    O=Other

    Default: C

    PTLT_LOAD_METHODCharacter(4)VARCHAR2(4) NOT NULLMethod of loading - has translates
    CMPI=Component Interface
    ETL=ETL
    ONLN=Online
    OTHR=Other

    Default: ONLN

    PTLT_NODMS_FLAGCharacter(1)VARCHAR2(1) NOT NULLFlag to disable data mover exporting

    Y/N Table Edit

    Default: N

    PTLT_CROSSDB_FLAGCharacter(1)VARCHAR2(1) NOT NULLCross Database Impact

    Y/N Table Edit

    Default: N

    NAVIGATIONCharacter(254)VARCHAR2(254) NOT NULLNavigation
    DESCR254_MIXEDCharacter(254)VARCHAR2(254) NOT NULLDescription
    OBJECTOWNERIDCharacter(4)VARCHAR2(4) NOT NULLObject owner identifier translate values
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19