PTLT_TASKLD_VW

index back

SELECT %Sql(PTLT_COMP_CODE) , '' ,'C' ,'ONLN' ,'N' ,'N' ,'' ,'' ,'PPT' FROM PSPNLGRPDEFN

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
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

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 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20