The V1URDFIL table is used for HSURDFIL and HSURDCOM views. The following table describes the columns in the V1URDFIL table:
| Column | Type | Length | Decimal | Domain |
|---|---|---|---|---|
| MACHINEID | CHARACTER | 10 | 0 | machine identifier |
| CDSOC | CHARACTER | 10 | 0 | company name |
| MCRECID | BINARY | 4 | 0 | machine/company ID |
| FILLIB | CHARACTER | 128 | 0 | file library |
| FILTYPE | CHARACTER | 4 | 0 | file type |
| TYPNAME | CHARACTER | 128 | 0 | ODBC Database Type Name |
| FILNAME | CHARACTER | 128 | 0 | file name |
| FILVER | BINARY | 3 | 0 | file version |
| RECFMT | CHARACTER | 10 | 0 | format of record |
| FILRECID | BINARY | 9 | 0 | file ID |
| TSNAME | CHARACTER | 24 | 0 | tablespace name |
| DBNAME | CHARACTER | 24 | 0 | database name |
| OBID | BINARY | 4 | 0 | OBID |
| APPLID | CHARACTER | 10 | 0 | application ID |
| FILTXT | CHARACTER | 50 | 0 | text |
| FREQLOG | CHARACTER | 1 | 0 | logging frequency |
| FREQSPE | CHARACTER | 1 | 0 | sampling frequency |
| FREQCORR | CHARACTER | 1 | 0 | data corruption frequency |
| NUMREC | BINARY | 9 | 0 | number of records |
| PROCID | CHARACTER | 5 | 0 | process ID |
| UNLFILTYP | CHARACTER | 4 | 0 | unload file type |
| UNLFILNAM | CHARACTER | 44 | 0 | unload file name |
| UNLFILVER | BINARY | 3 | 0 | unload file version |
| RECLEN | BINARY | 5 | 0 | length of record |
| FMTSEL | CHARACTER | 8 | 0 | format selector |
| DATEANA | CHARACTER | 8 | 0 | date of analysis |
| DATECAL | CHARACTER | 8 | 0 | date of last calculation |
| DATELOG | CHARACTER | 8 | 0 | date of last log |
| DATESPE | CHARACTER | 8 | 0 | date of last spectrum |
| DATECORR | CHARACTER | 8 | 0 | date of last data corruption |
| MBFTYP | CHARACTER | 1 | 0 | type of file |
| ANALYSIS | CHARACTER | 1 | 0 | analysis state |
| RECANAL | BINARY | 9 | 0 | number of record analyzed |
| CPYLIB | CHARACTER | 44 | 0 | associated copybook PDS |
| CPYNAME | CHARACTER | 10 | 0 | associated copybook name |
| IOAREANAME | CHARACTER | 30 | 0 | I/O area name |
| IOAREAPRG | BINARY | 3 | 0 | I/O area progressive |
| INFOPROV | CHARACTER | 3 | 0 | information provider |
| FILNICK | CHARACTER | 10 | 0 | nickname of file |
| LOGMON | CHARACTER | 1 | 0 | logging enabled |
| DCMON | CHARACTER | 1 | 0 | data corruption enabled |
| LOGALARM | CHARACTER | 1 | 0 | logging alarm |
| DCALARM | CHARACTER | 1 | 0 | data corruption alarm |
| FLANAG | CHARACTER | 1 | 0 | is demographic |
| COENAB | CHARACTER | 1 | 0 | data consistency |
| DATECO | CHARACTER | 8 | 0 | consistency date |
| FANAGPRO | CHARACTER | 3 | 0 | demographic provider |
| FILCAT | CHARACTER | 10 | 0 | file category |
| FLAG01 | CHARACTER | 1 | 0 | FB or VB flag |
| FLAG02 | CHARACTER | 1 | 0 | currently unused |
| FLAG03 | CHARACTER | 1 | 0 | currently unused |
| FLAG04 | CHARACTER | 1 | 0 | currently unused |
| FLAG05 | CHARACTER | 1 | 0 | currently unused |