RS_XS_CSACMPDEG

(SQL View)

SELECT A.SETID , A.CUST_ID , %TrimSubstr(A.SETID,1,5) %Concat '' %Concat %TrimSubstr(A.CUST_ID,1,15) AS CUSTID , %TrimSubstr(B.ACCOMPLISHMENT,1,8) %Concat 'x' %Concat %TrimSubstr(B.MAJOR_CODE,1,10) AS DEG , CASE WHEN B.WEIGHT_POINTS = 0 THEN 'Y' ELSE 'N' END AS REQ , CASE WHEN B.WEIGHT_POINTS = 0 THEN %TrimSubstr(B.ACCOMPLISHMENT,1,8) %Concat 'x' %Concat %TrimSubstr(B.MAJOR_CODE,1,10) ELSE ' ' END AS RDEG FROM %Table(CUSTOMER) A , %Table(FO_CUST_ACMP_DG) B WHERE A.SETID = B.SETID AND A.CUST_ID = B.CUST_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 CUST_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 SOID Character(29) VARCHAR2(29) NOT NULL Service Order Line Key

4 DEG Character(32) VARCHAR2(32) NOT NULL Accomplishment

5 REQ Character(1) VARCHAR2(1) NOT NULL Purchasing

6 RDEG Character(32) VARCHAR2(32) NOT NULL Accomplishment

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	CUST_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	SOID	Character(29)	VARCHAR2(29) NOT NULL	Service Order Line Key
4	DEG	Character(32)	VARCHAR2(32) NOT NULL	Accomplishment
5	REQ	Character(1)	VARCHAR2(1) NOT NULL	Purchasing
6	RDEG	Character(32)	VARCHAR2(32) NOT NULL	Accomplishment