PTLT_TASKLD_VW

index back

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

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

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