PTREPNAMEDefault Value: DMW
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
Default Value: %datetime
Prompt Table: PSOPRDEFN
Default Value: %datetime
Prompt Table: PSOPRDEFN
PSPRJREP_DMW_VW(SQL View) |
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 | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTREPNAME |
Character(30) | VARCHAR2(30) NOT NULL | Location Name |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | PTREPPATH | Character(254) | VARCHAR2(254) NOT NULL | Repository Path |
| 4 | PT_PROCESS_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Process Type
Default Value: DMW |
| 5 | PT_ALLOW_LOCAL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Allow Local Paths
Y/N Table Edit Default Value: N |
| 6 | PT_CLEANUP_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Clean Up After Processing
Y/N Table Edit Default Value: N |
| 7 | CREATEDTTM | DateTime(26) | TIMESTAMP NOT NULL |
DateTime of Query Creation
Default Value: %datetime |
| 8 | CREATEOPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID
Prompt Table: PSOPRDEFN |
| 9 | 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 Value: %datetime |
| 10 | 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 |