RS_XS_CNACMPLIC

(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.COUNTRY,1,3) %Concat 'x' %Concat %TrimSubstr(B.STATE,1,6) AS LIC , 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.COUNTRY,1,3) %Concat 'x' %Concat %TrimSubstr(B.STATE,1,6) ELSE ' ' END AS RLIC FROM %Table(CONTACT) A , %Table(CONT_ACMP_LIC) 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 LIC Character(32) VARCHAR2(32) NOT NULL License
5 REQ Character(1) VARCHAR2(1) NOT NULL Purchasing
6 RLIC Character(32) VARCHAR2(32) NOT NULL Required License