INSTANCEIDPT_ACMDASHTBL(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DATACHUNK | Long Character | CLOB | Data Chunk |
| 2 | DBNAME | Character(8) | VARCHAR2(8) NOT NULL | Database Name |
| 3 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 4 | PLUGIN_NAME | Character(30) | VARCHAR2(30) NOT NULL | Plug-In Name |
| 5 | PTSHOWTIME1 | Character(25) | VARCHAR2(25) NOT NULL | Intial Time |
| 6 | PTSHOWTIME2 | Character(25) | VARCHAR2(25) NOT NULL | Intial Time |
| 7 | INSTANCEID |
Number(10,0) | DECIMAL(10) NOT NULL | For a given worklist the unique number of rows in PSWORKLIST |