Government Database Tables and Columns 55
PLUSRVHEADER Table
PLUSRVPROPERTY Table
TRANSPERSONID 1 UPPER 30
UPLOADFILEID 1 INTEGER 12
COLUMN REQUIRED MAXTYPE LENGTH
COLUMN REQUIRED MAXTYPE LENGTH
EMAIL 0 ALN 50
INDUSTRYFLAG 1 ALN 1
NAME 1 UPPER 30
ORGANIZATION 1 UPPER 20
PHONE 1 ALN 20
RECORDCOUNT 0 INTEGER 12
REPORTNUM 1 UPPER 12
REPORTNUMNP 0 UPPER 12
COLUMN REQUIRED MAXTYPE LENGTH
ASSETNUM 0 UPPER 12
CONTRACTNUM 0 UPPER 8
CONTRACTOR 0 UPPER 12
CUSTODIANPERSONID 0 UPPER 30
EXTERNALSYSTEM 0 UPPER 25
FILEFORMAT 0 UPPER 25
ITEMNUM 0 UPPER 30
ITEMSETID 0 UPPER 8
LOCATION 0 UPPER 12
ORGID 1 UPPER 8
PRICE 0 AMOUNT 10
PROPERTYCLASS 0 UPPER 25
QUANTITY 0 DECIMAL 15
SITEID 0 UPPER 8
SOURCE 0 UPPER 25
TOCONTRACT 0 UPPER 8