357

TNRD Julian Date

Date

6

Customer-specific Julian data offset from 1/1/1975

358

TNRD Rev Julian Date

Date

6

Customer-specific reverse Julian data offset from 1/1/1975

359

TNRD Identification number

Varchar

-1

Customer-specific suffix delimited ID number

360

TNRD Surname

Varchar

-1

Customer-specific suffix delimited Surname

361

TNRD First Name and Initial

Varchar

-1

Customer-specific suffix delimited First name and initial

362

TNRD Care of

Varchar

-1

Customer-specific suffix delimited Care of

363

TNRD Street Address Number

Varchar

-1

Customer-specific suffix delimited Street Address Number

364

TNRD Street Address Name

Varchar

-1

Customer-specific suffix delimited Street Address Name

365

TNRD St Address City/Province

Varchar

-1

Customer-specific suffix delimited Street Address City and Province

366

TNRD St Address Postal Code

Varchar

-1

Customer-specific suffix delimited Street Address Postal Code

367

TNRD Home Phone

Varchar

-1

Customer-specific suffix delimited Home Phone

368

TNRD Work Phone

Varchar

-1

Customer-specific suffix delimited Work Phone

369

TNRD Alt Address Num & Street

Varchar

-1

Customer-specific suffix delimited Alternate Street Address Number and Name

370

TNRD Alt Address City & Prov

Varchar

-1

Customer-specific suffix delimited Alternate Address City and Province

371

TNRD Alt Address Postal Code

Varchar

-1

Customer-specific suffix delimited Alternate Address Postal Code

372

TNRD School

Varchar

-1

Customer-specific suffix delimited School

373

TNRD Parent or Guardian

Varchar

-1

Customer-specific suffix delimited Parent or Guardian

374

TNRD Previous Barcode

Varchar

-1

Customer-specific suffix delimited Previous Barcode

375

TNRD Next Barcode

Varchar

-1

Customer-specific suffix delimited Next Barcode

376

TNRD Xref See

Long

4

Customer-specific prefix delimited See

377

TNRD Xref See Also

Long

4

Customer-specific prefix delimited See Also

378

TNRD Xref See From

Long

4

Customer-specific prefix delimited See From

379

TNRD Xref See Also From

Long

4

Customer-specific prefix delimited See Also From

380

TNRD Notes

Varchar

-1

Customer-specific prefix delimited Notes

381

Marc BIB Decimal

Decimal

21

Customer-specific base 240 number conversion

382

Marc BIB Tag

Long

4

Customer-specific base 240 number conversion

383

Adonix Date

Date

6

Customer-specific Julian date offset from 12/31/1599

384

Text Left Space Pad -> FmtDbl

DOUBLE

8

385

Numeric Data (YYMMDD)

Date

6

Three- byte date field where the date is taken from the decimal digits of the values. Thus a numeric value of 750824 is interpreted as August 24 1975. Note that the year field uses a century window where values < 25 are assigned century 2000, everything else 1900.

The new function is far more customer specific:

TPADateOfBirth(date, centuryCode)

Inputs:

date - base birth date, for example a field of Numeric Date type.

centuryCode - integer value indicating century of birth, 8 = 1800, 9 = 1900, 0 == 2000, no other valid values.

386

VISTA Date (Julian 12/31/1919)

Date

6

Julian Date offset from 12/31/1919.

387

DBMS Key

CHAR

22

388

Encapsulated Date (cyMMDD)

DATE

6

Byte 0 -> binary number representing the most significant two digits of a four digit year.

Byte 1 -> binary number representing the least significant two digits of a four digit year.

Thus, if given the first two bytes values of 20, 03, the year for this date are 2003.

Bytes 2 & 3 are the numeric characters representing the month of the year.

Bytes 4 & 5 are the numeric characters representing the day of the month.

Thus a value of 0x010131313131 is a date of November (month 11) 11 (day 11) in the year 101.

389

Rev Encapsulated Date (MMDDcy)

DATE

6

Byte 0 -> binary number representing the most significant two digits of a four digit year.

Byte 1 -> binary number representing the least significant two digits of a four digit year.

Thus, if given the first two bytes values of 20, 03, the year for this date are 2003.

Bytes 2 & 3 are the numeric characters representing the month of the year.

Bytes 4 & 5 are the numeric characters representing the day of the month.

Thus a value of 0x010131313131 is a date of November (month 11) 11 (day 11) in the year 101.

390

Text (Right Space Padded)

CHAR

-1

391

Text (Expandable)

VARCHAR

-1

392

Text Date (YYYYMM)

DATE

6

For YYYYMM , if YYYYMM was 200203, the SQL date would be March 1, 2003.

The day of the month is always one (1).

393

Text Date 2000 (YYMM)

DATE

6

For YYMM , if YYMM was 0304, the SQL date would be April 1, 2003.

The day of the month is always one (1).

For YYMM , if YYMM was 2304, the SQL date would be April 1, 1923.

The day of the month is always one (1).

The break Year = 20 (For years below 20, add 2000; for years above 20, add 1900. The break year is configurable.)

394

Text Date (MMYYYY)

DATE

6

For MMYYYY , if MMYYYY was 032002, the SQL date would be March 1, 2003.

The day of the month is always one (1).

395

Text Date 2000 (MMYY)

DATE

6

For MMYY , if MMYY was 0403, the SQL date would be April 1, 2003.

The day of the month is always one (1).

For MMYY , if MMYY was 0423, the SQL date would be April 1, 1923.

The day of the month is always one (1).

The break Year = 20 (For years below 20, add 2000; for years above 20, add 1900. The break year is configurable.)

396

Text Date (YYYY)

DATE

6

For YYYY, if YYYY was 2004, the SQL Date would be January 1, 2004.

The day of the month is always one (1).

The month is always January.

397

Text Date 2000 (YY)

DATE

6

for YY, if YY was 04, the SQL Date would be January 1, 2004.

The day of the month is always one.

The month is always January.

For YY, if YY was 34, the SQL Date would be January 1, 1934.

The day of the month is always one (1).

The month is always January.

The break Year = 20 (For years below 20, add 2000; for years above 20, add 1900. The break year is configurable.)

398

Text Date (MM)

DATE

6

For MM, if MM was 11, the SQL Date would be November 1, 2003.

The year returned is the current year.

The day of the month is always one (1).

399

Text Date (DD)

DATE

6

For DD, if DD = 30, the SQL Date would be January 30, 2003.

The year returned is the current year.

The month is always January.

400

Fairfield Text Date (MMDD)

DATE

6

For MMDD, if MM were 11 and DD were 20, then the SQL Date would be November 20, 1900. The year returned is always 1900.

401

Fairfield Text Date (MM)

DATE

6

For MMDD, if MM were 11 and DD were 20, then the SQL Date would be November 20, 1900. The year returned is always 1900.

402

Fairfield Text Date (DD)

DATE

6

For DD, if DD were 20, then the SQL Date would be January 20, 1900. The year returned in always 1900. The month returned is always January.

403

Adabas Natural Date

DATE

6

404

Adabas Natural Time

TIME

6

405

VMS Double -> Currency

Currency

21

406

PostgreSQL Numeric -> Decimal

DECIMAL

-15