DFW_RD(SQL View) |
Index Back |
|---|
| SELECT A.PRCSINSTANCE , A.CONTENTID , A.PRCSNAME , A.RQSTDTTM , A.ENDDTTM , A.DISTSTATUS , B.TRANSFERINSTANCE FROM PS_CDM_LIST A , PS_CDM_TRANSFER B WHERE A.TRANSFERINSTANCE = B.TRANSFERINSTANCE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PRCSINSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | CONTENTID | Number(15,0) | DECIMAL(15) NOT NULL | Report ID |
| 3 | PRCSNAME | Character(12) | VARCHAR2(12) NOT NULL | Process Name |
| 4 | RQSTDTTM | DateTime(26) | TIMESTAMP | Request Date/Time |
| 5 | ENDDTTM | DateTime(26) | TIMESTAMP | End Date/Time |
| 6 | DISTSTATUS | Character(2) | VARCHAR2(2) NOT NULL |
Distribution Status
0=None 1=Scheduled 2=Processing 3=Generated 4=Unable to Post 5=Posted to Web 6=Delete 7=Posting 9=Pending for Approval |
| 7 | TRANSFERINSTANCE | Number(15,0) | DECIMAL(15) NOT NULL | Transfer Instance |