CONSUMER_INV (SQL Table)	Index Back
Consumer This table identifies all of the consumers being serviced. The data in this table is fed by an external system and is not maintained by a PeopleSoft panel.

CONSUMER_INV

(SQL Table)

Consumer

This table identifies all of the consumers being serviced. The data in this table is fed by an external system and is not maintained by a PeopleSoft panel.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 CONSUMER_ID Character(20) VARCHAR2(20) NOT NULL A unique identifier for an individual that consumes or uses materials.

3 CONSUMER_NAME Character(48) VARCHAR2(48) NOT NULL The legal name of the consumer.