PRCSJOBNAMEPTRCJOBDEFN_VW(SQL View) |
Index Back |
|---|---|
Job Definition ViewReporting Console |
| SELECT J.PRCSTYPE , J.PRCSJOBNAME , J.PRCSJOBNAME , J.PT_PRCS_EN_GEN_RUN , J.DESCR FROM PS_PRCSJOBDEFN J |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PRCSTYPE | Character(30) | VARCHAR2(30) NOT NULL | Process Type |
| 2 | PRCSJOBNAME |
Character(8) | VARCHAR2(8) NOT NULL | Process Job Name |
| 3 | PRCSNAME | Character(12) | VARCHAR2(12) NOT NULL | Process Name |
| 4 | PT_PRCS_EN_GEN_RUN | Character(1) | VARCHAR2(1) NOT NULL | Enable Generic RunControl Page |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |