PROCESS_INSTANCEA=Active
I=Inactive
IT_SDMON_AET(SQL Table) |
Index Back |
|---|---|
IT SD Monitor Work RecordIT SD Monitor |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | COUNT_1 | Number(3,0) | SMALLINT NOT NULL | Count Work Field |
| 3 | COUNT_2 | Number(3,0) | SMALLINT NOT NULL | Count Work Field |
| 4 | ACTIVE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Active Flag
A=Active I=Inactive |
| 5 | IT_GRP_ID | Character(11) | VARCHAR2(11) NOT NULL | Employee Group Id |
| 6 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 7 | SFTWR_TITLE | Character(50) | VARCHAR2(50) NOT NULL | Software Title |
| 8 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 9 | LOOP_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Looping |
| 10 | DUPLICATE_FLG | Character(1) | VARCHAR2(1) NOT NULL | duplicate flag |