PROCESS_INSTANCEQS_PURGE_AET(SQL Table) |
Index Back |
|---|---|
Data Mover App Eng state recState record for data mover application engine program - used to pass values between program steps |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SESSN_ID | Character(30) | VARCHAR2(30) NOT NULL | Session ID |
| 3 | STREAM_ID | Number(8,0) | INTEGER NOT NULL | Stream ID- hierarchial structure plus characteristic. (or Stream Root ID plus characteristic). |
| 4 | SESSN_CRE_DTTM | DateTime(26) | TIMESTAMP | Date Created |
| 5 | SCNTL_SESSN_LIFE | Number(3,0) | SMALLINT NOT NULL | Session Data Life Days |
| 6 | QS_PURGE_COUNT | Number(6,0) | INTEGER NOT NULL | number of DE sessions purged |