SEQ_RANGE_IDBEGIN_DTDefault Value: N
SEQ_RANGE_DETL(SQL Table) |
Index Back |
|---|---|
Sequence Range Detial Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SEQ_RANGE_ID |
Character(2) | VARCHAR2(2) NOT NULL | Sequence Range |
| 2 | BEGIN_DT |
Date(10) | DATE NOT NULL | Begin Date |
| 3 | END_DT | Date(10) | DATE NOT NULL | End Date |
| 4 | SEQ_NBR_PREFIX | Character(4) | VARCHAR2(4) NOT NULL | Sequence Number Prefix |
| 5 | SEQ_NBR_START | Number(12,0) | DECIMAL(12) NOT NULL | Start Sequence Number |
| 6 | SEQ_NBR_END | Number(12,0) | DECIMAL(12) NOT NULL | End Sequence Number |
| 7 | IN_USE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Row in use flag
Default Value: N |