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 Name Field Type Column Type Description
PTREPNAME Character(30) VARCHAR2(30) NOT NULL Location Name
DESCR Character(30) VARCHAR2(30) NOT NULL Description
PTREPPATH Character(254) VARCHAR2(254) NOT NULL Repository Path
PT_PROCESS_TYPE Character(4) VARCHAR2(4) NOT NULL Process Type

Default: DMW

PT_ALLOW_LOCAL_FLG Character(1) VARCHAR2(1) NOT NULL Allow Local Paths

Y/N Table Edit

Default: N

PT_CLEANUP_FLG Character(1) VARCHAR2(1) NOT NULL Clean Up After Processing

Y/N Table Edit

Default: N

CREATEDTTM DateTime(26) TIMESTAMP NOT NULL DateTime of Query Creation

Default: %datetime

CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID

Prompt Table: PSOPRDEFN

LASTUPDDTTM DateTime(26) TIMESTAMP NOT NULL Specifies 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

LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies 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 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20