RE_SAR_METRICS (SQL Table)	Index Back
SAR Metrics

RE_SAR_METRICS

(SQL Table)

SAR Metrics

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SAR_ID Character(15) VARCHAR2(15) NOT NULL SAR ID

2 SITE_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

3 SITE_ATTRIBUTE Character(60) VARCHAR2(60) NOT NULL Attributes

4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

5 WEIGHTAGE Number(6,2) DECIMAL(5,2) NOT NULL Weighting

6 ATTR_GRP Character(15) VARCHAR2(15) NOT NULL Attribute Group

7 ATTR_RATING1 Character(1) VARCHAR2(1) NOT NULL Attribute Rating
1=1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SAR_ID	Character(15)	VARCHAR2(15) NOT NULL	SAR ID
2	SITE_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
3	SITE_ATTRIBUTE	Character(60)	VARCHAR2(60) NOT NULL	Attributes
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	WEIGHTAGE	Number(6,2)	DECIMAL(5,2) NOT NULL	Weighting
6	ATTR_GRP	Character(15)	VARCHAR2(15) NOT NULL	Attribute Group
7	ATTR_RATING1	Character(1)	VARCHAR2(1) NOT NULL	Attribute Rating 1=1