RS_XS_CNACMPDEG

(SQL View)
 Index Back

SELECT A.SETID , A.CONTACT_ID , %TrimSubstr(A.SETID,1,5) %Concat '' %Concat %TrimSubstr(A.CONTACT_ID,1,15) AS CONTACT , %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(CONTACT) A , %Table(CONT_ACMP_DEG) B WHERE A.SETID = B.SETID AND A.CONTACT_ID = B.CONTACT_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
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