FF_FILEVER_VW

(SQL View)
 Index Back

SELECT A.FF_FILE_NAME , A.FF_VERSION , %TrimSubstr(A.FF_FILE_NAME,1,30) %Concat '.' %Concat %TrimSubstr(A.FF_VERSION,1,30) FROM PS_FF_SETTINGS A WHERE EXISTS ( SELECT 'X' FROM PS_FF_ACCESSAUTH B WHERE B.FF_ACCESSID = A.FF_ACCESSID AND B.FF_GENERATE='Y' AND ((B.AUTHORIDTYPE = '2' AND B.AUTHORID = %OperatorId) ) OR (B.AUTHORIDTYPE = '3' AND B.AUTHORID IN ( SELECT RL.ROLENAME FROM PSROLEUSER RL WHERE RL.ROLEUSER = %OperatorId))) AND A.FF_FILE_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FF_FILE_NAME Character(30) VARCHAR2(30) NOT NULL Flat file name
2 FF_VERSION Character(30) VARCHAR2(30) NOT NULL Message Version
3 FF_RUNFILEVERSION Character(61) VARCHAR2(61) NOT NULL File.Version to generate