Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse VAPS POLI Table


XXX


Field Name

Description

Data Type

Length

POLI_ADDED_AGENCY

XXX

VARCHAR2

1

POLI_ADDED_BY

XXX

VARCHAR2

13

POLI_ADDED_DATE

XXX

VARCHAR2

12

POLI_AMT

XXX

NUMBER

11,2

POLI_CAS

XXX

NUMBER

8

POLI_CO_NUM

XXX

NUMBER

3

POLI_CUM_AMT

XXX

NUMBER

11,2

POLI_CUM_QTY

XXX

NUMBER

11,3

POLI_DESCRIPTION

XXX

VARCHAR2

1000

POLI_DISC_D

XXX

NUMBER

11,2

POLI_DISC_P

XXX

NUMBER

11,3

POLI_DISC_TYPE

XXX

VARCHAR2

1

POLI_EQUIPMENT

XXX

VARCHAR2

1

POLI_EST_DATE

XXX

DATE

POLI_FORMAT

XXX

VARCHAR2

1

POLI_INV_GROUP

XXX

VARCHAR2

4

POLI_LI_NUM

XXX

NUMBER

3

POLI_LOG

XXX

VARCHAR2

1

POLI_PO_NUM

XXX

NUMBER

7

POLI_PRICE

XXX

NUMBER

13,5

POLI_QTY

XXX

NUMBER

11,3

POLI_REQD_DATE

XXX

VARCHAR2

10

POLI_REQ_ID

XXX

VARCHAR2

12

POLI_SUBTYPE

XXX

VARCHAR2

1

POLI_TYPE

XXX

VARCHAR2

1

POLI_UNITS

XXX

VARCHAR2

12

POLI_VEN_PART_NUM

XXX

VARCHAR2

13

POLI_WO_NUM

XXX

NUMBER

7