PROCESS_INSTANCESCC_SEQ_IDDefault Value: 1
SCC_BAT_NTF_TGT(SQL Table) |
Index Back |
|---|---|
Bat Ntf results rec |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SCC_SEQ_ID |
Number(10,0) | DECIMAL(10) NOT NULL |
Sequence ID
Default Value: 1 |
| 3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | NUMBER2 | Number(2,0) | SMALLINT NOT NULL | Number |
| 5 | NUMBER10 | Number(10,0) | DECIMAL(10) NOT NULL | Number |
| 6 | NUMBER20 | Number(20,0) | DECIMAL(20) NOT NULL | Number |
| 7 | DATETIME1 | DateTime(26) | TIMESTAMP | DateTime |
| 8 | DATETIME2 | DateTime(26) | TIMESTAMP | DateTime |
| 9 | DATETIME3 | DateTime(26) | TIMESTAMP | DateTime |
| 10 | DATE1 | Date(10) | DATE | Date 1 |
| 11 | DATE2 | Date(10) | DATE | Date 2 |
| 12 | DATE3 | Date(10) | DATE | Date 3 |
| 13 | DESCR5_1 | Character(5) | VARCHAR2(5) NOT NULL | Description |
| 14 | DESCR5_2 | Character(5) | VARCHAR2(5) NOT NULL | Description |
| 15 | DESCR5_3 | Character(5) | VARCHAR2(5) NOT NULL | Description |
| 16 | DESCR10 | Character(10) | VARCHAR2(10) NOT NULL | Description field of length 10 |
| 17 | DESCR20 | Character(20) | VARCHAR2(20) NOT NULL | Description |
| 18 | DESCR30 | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 19 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 20 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 21 | DESCR35 | Character(35) | VARCHAR2(35) NOT NULL | Description |
| 22 | DESCR35_1 | Character(35) | VARCHAR2(35) NOT NULL | Description |
| 23 | DESCR50_1 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 24 | DESCR100_2 | Character(100) | VARCHAR2(100) NOT NULL | Description |
| 25 | DESCRLONG | Long Character | CLOB | Long Description |