PTLT_CMPTASK_VW

index back

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

PeopleSoft Field NameField TypeColumn TypeDescription
PTLT_TASK_CODECharacter(30)VARCHAR2(30) NOT NULLTask Code
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

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