PSPRJREP_DMW_VW

index back

ADS Project Repository


SELECT PTREPNAME , DESCR , PTREPPATH , PT_PROCESS_TYPE , PT_ALLOW_LOCAL_FLG , PT_CLEANUP_FLG , CREATEDTTM , CREATEOPRID , LASTUPDDTTM , LASTUPDOPRID FROM PSPRJREPOSITORY WHERE PT_PROCESS_TYPE = 'DMW'

PeopleSoft Field NameField TypeColumn TypeDescription
PTREPNAMECharacter(30)VARCHAR2(30) NOT NULLLocation Name
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
PTREPPATHCharacter(254)VARCHAR2(254) NOT NULLRepository Path
PT_PROCESS_TYPECharacter(4)VARCHAR2(4) NOT NULLProcess Type

Default: DMW

PT_ALLOW_LOCAL_FLGCharacter(1)VARCHAR2(1) NOT NULLAllow Local Paths

Y/N Table Edit

Default: N

PT_CLEANUP_FLGCharacter(1)VARCHAR2(1) NOT NULLClean Up After Processing

Y/N Table Edit

Default: N

CREATEDTTMDateTime(26)TIMESTAMP NOT NULLDateTime of Query Creation

Default: %datetime

CREATEOPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID

Prompt Table: PSOPRDEFN

LASTUPDDTTMDateTime(26)TIMESTAMP NOT NULLSpecifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

Default: %datetime

LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

Prompt Table: PSOPRDEFN

index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19