RS_SO_LN_AT_VAL (SQL Table)	Index Back
SO line attributes and values This table contains the desired or required attributes and attribute values for each service order line or each resource request.

RS_SO_LN_AT_VAL

(SQL Table)

SO line attributes and values

This table contains the desired or required attributes and attribute values for each service order line or each resource request.

Audit Record: RS_SO_AUDIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID

3 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number

4 RS_ATTRIBUTE_ID Character(10) VARCHAR2(10) NOT NULL This field is used to uniquely identify an attribute of an assignment or project. An attribute may be captured on the service order and/or may be captured as an assignment preference by the worker.

5 RS_ATTR_VAL_ID Character(10) VARCHAR2(10) NOT NULL Attribute Value ID
Prompt Table: %EDITTABLE3

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	SO_ID	Character(15)	VARCHAR2(15) NOT NULL	Service Order ID
3	SO_LINE	Number(3,0)	SMALLINT NOT NULL	Line Number
4	RS_ATTRIBUTE_ID	Character(10)	VARCHAR2(10) NOT NULL	This field is used to uniquely identify an attribute of an assignment or project. An attribute may be captured on the service order and/or may be captured as an assignment preference by the worker.
5	RS_ATTR_VAL_ID	Character(10)	VARCHAR2(10) NOT NULL	Attribute Value ID Prompt Table: %EDITTABLE3