SPF_NXBDACT_LNG

(SQL View)
Index Back

next bid action lang table

used for translations to bring up the translated descr for the bid action in the code prompt on the bidding pages.

SELECT A.SPF_FROM_USERTYPE , A.SPF_TO_USERTYPE , A.SPF_LAST_ACT_TYPE , A.SPF_LAST_ACT_CODE , A.SPF_NEXT_ACT_TYPE , A.SPF_NEXT_ACT_CODE , B.LANGUAGE_CD , B.DESCR FROM PS_SPF_NXT_BID_ACT A , PS_SPF_BIDACT_LANG B WHERE A.SPF_NEXT_ACT_TYPE = B.BID_ACTION_TYPE AND A.SPF_NEXT_ACT_CODE = B.CODE

  • Related Language Record for SPF_NX_BDACT_VW SPF_NX_FDACT_VW SPF_NX_FDRAC_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SPF_FROM_USERTYPE Character(4) VARCHAR2(4) NOT NULL Sent From user type used for determining the available bid actions
    REQ=Requester
    SPC=Service Provider Contact
    SVC=Service Coordinator
    2 SPF_TO_USERTYPE Character(4) VARCHAR2(4) NOT NULL Sent to User Type used for determining the next available bid actions
    REQ=Requester
    SPC=Service Provider Contact
    SVC=Service Coordinator
    3 SPF_LAST_ACT_TYPE Character(5) VARCHAR2(5) NOT NULL The last bid action type
    4 SPF_LAST_ACT_CODE Character(4) VARCHAR2(4) NOT NULL the last bid action code
    5 SPF_NEXT_ACT_TYPE Character(5) VARCHAR2(5) NOT NULL the next bid action type
    6 SPF_NEXT_ACT_CODE Character(4) VARCHAR2(4) NOT NULL the next bid action code
    7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description