1.11.1 Segment Identification Number
This topic provides detailed information on holiday upload format of segment identification number.
Table 1-77 Segment Identification Number
| Field Name (as expected in the file) | Data type | Length | Mandatory/ Optional | Characteristics/rules | Values |
|---|---|---|---|---|---|
| SEQUENCENUMBER | NUMBER | 10 | Mandatory | - | Sequence Number |
| PROCESSID | VARCHAR2 | 50 | Mandatory | - | Process ID |
| BULKCLIENTCODE | VARCHAR2 | 12 | Mandatory | - | Bulk Client Code |
| IMPORTFILENAME | VARCHAR2 | 255 | Mandatory | - | Import file Name |
| UPLOADMODE | VARCHAR2 | 1 | Mandatory | - | Mode of operation which has to be performed on the record |
| AMCID | VARCHAR2 | 12 | Optional | - | AMC ID |
| YEAR | NUMBER | 4 | Mandatory | - | Year |
| JAN | VARCHAR2 | 100 | Optional | - | Holiday Bits For Jan. Eg) 000000000000000 00011100000 |
| FEB | VARCHAR2 | 100 | Optional | - | Holiday Bits For February |
| MAR | VARCHAR2 | 100 | Optional | - | Holiday Bits For March |
| APR | VARCHAR2 | 100 | Optional | - | Holiday Bits For April |
| MAY | VARCHAR2 | 100 | Optional | - | Holiday Bits For May |
| JUN | VARCHAR2 | 100 | Optional | - | Holiday Bits For June |
| JUL | VARCHAR2 | 100 | Optional | - | Holiday Bits For July |
| AUG | VARCHAR2 | 100 | Optional | - | Holiday Bits For August |
| SEP | VARCHAR2 | 100 | Optional | - | Holiday Bits For September |
| OCT | VARCHAR2 | 100 | Optional | - | Holiday Bits For October |
| NOV | VARCHAR2 | 100 | Optional | - | Holiday Bits For November |
| DEC | VARCHAR2 | 100 | Optional | - | Holiday Bits For December |
| USERID | VARCHAR2 | 15 | Mandatory | - | Represents the user ID who has entered the latest record |
| AUTH_STAT | VARCHAR2 | 1 | Mandatory | - |
Authorisation Status:
|
| ENTITYTYPE | VARCHAR2 | 1 | Mandatory | - | Entity Type |
| ENTITYID | VARCHAR2 | 12 | Mandatory | - | Entity ID |
Parent topic: Holiday Upload Format