RS_SO_ORG (SQL Table)	Index Back
Service order Org Structure This record is created to store the Organisation structure details of all Service Order created in Resource Management whose status as of current date is not in 'C' or 'X'.

RS_SO_ORG

(SQL Table)

Service order Org Structure

This record is created to store the Organisation structure details of all Service Order created in Resource Management whose status as of current date is not in 'C' or 'X'.

# 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 SETID Character(5) VARCHAR2(5) NOT NULL SetID

4 NODE_DETAIL Character(1) VARCHAR2(1) NOT NULL Tree Node or Tree detail Value
D=Detail
N=Node

5 NODE_NAME Character(40) VARCHAR2(40) NOT NULL Node Name

#	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	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
4	NODE_DETAIL	Character(1)	VARCHAR2(1) NOT NULL	Tree Node or Tree detail Value D=Detail N=Node
5	NODE_NAME	Character(40)	VARCHAR2(40) NOT NULL	Node Name