CONSUMER_TMP (SQL Table)	Index Back
Consumer Table 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_TMP

(SQL Table)

Consumer Table

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.

4 SAVE_PB Character(1) VARCHAR2(1) NOT NULL &Save

#	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.
4	SAVE_PB	Character(1)	VARCHAR2(1) NOT NULL	&Save