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 Name Field Type Column Type Description
    PTLT_TASK_CODE Character(30) VARCHAR2(30) NOT NULL Task Code
    PTLT_TASK_NAME Character(30) VARCHAR2(30) NOT NULL Task Name
    PTLT_TASK_TYPE Character(1) VARCHAR2(1) NOT NULL Task Type
    C=Component
    O=Other

    Default: C

    PTLT_LOAD_METHOD Character(4) VARCHAR2(4) NOT NULL Method of loading - has translates
    CMPI=Component Interface
    ETL=ETL
    ONLN=Online
    OTHR=Other

    Default: ONLN

    PTLT_NODMS_FLAG Character(1) VARCHAR2(1) NOT NULL Flag to disable data mover exporting

    Y/N Table Edit

    Default: N

    PTLT_CROSSDB_FLAG Character(1) VARCHAR2(1) NOT NULL Cross Database Impact

    Y/N Table Edit

    Default: N

    NAVIGATION Character(254) VARCHAR2(254) NOT NULL Navigation
    DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
    OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier translate values
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19