RS_RR_VER_VW (SQL View)	Index Back
Resource Request Version Lists the version -- the datetime last updated -- of each resource request. An "update" is any change to the service order line, to any of it's children, or to it's header.

RS_RR_VER_VW

(SQL View)

Resource Request Version

Lists the version -- the datetime last updated -- of each resource request. An "update" is any change to the service order line, to any of it's children, or to it's header.

SELECT %Sql(RS_FRAG_RR_KEY_SELECT, A) , MAX(B.AUDIT_STAMP) FROM %Table(RS_SO_LINE) A , %Table(RS_SO_AUDIT) B WHERE ((%Join(COMMON_KEYS, RS_SO_LINE B, RS_SO_LINE A)) OR (B.SO_LINE = 0 AND %Join(COMMON_KEYS, RS_SO_HDR B, RS_SO_HDR A))) AND AUDIT_RECNAME IN ('RS_SO_HDR','RS_SO_LINE','RS_SO_LINE_COMP','RS_SO_ACMP_DEG','RS_SO_ACMP_LIC','RS_SO_ACMP_LNG', 'RS_SO_LINE_REC','RS_RR_RQ_AT_VW','RS_RRRQATVAL_VW','RS_SO_LN_AT_VAL','RS_RR_AT_MNY_VW','RS_RR_AT_VAL_VW','RS_SO_ACMP_MEM') GROUP BY %Sql(RS_FRAG_RR_KEY_SELECT, A)

# 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 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.