SCC_PS_SFACP_BN

(SQL View)
Index Back

Pop Sel Bind for SFAC - Person

PopSel Bind record for SFAC Person Based admin function used by 3C Engine

SELECT A.BUSINESS_UNIT ,A.EMPLID ,A.ACCOUNT_NBR ,A.ACCOUNT_TERM ,C.INSTITUTION ,B.NAME FROM PS_ACCOUNT_SF A , PS_SCC_PRI_NAME_VW B ,PS_BUS_UNIT_TBL_SF C WHERE A.EMPLID = B.EMPLID AND B.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_SCC_PRI_NAME_VW X WHERE X.EMPLID = B.EMPLID AND X.EFFDT <= %CurrentDateIn) AND C.BUSINESS_UNIT=A.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_SF_NONVW

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

3 ACCOUNT_NBR Character(10) VARCHAR2(10) NOT NULL Account Nbr
4 ACCOUNT_TERM Character(4) VARCHAR2(4) NOT NULL Account Term

Prompt Table: TERM_VAL_TBL

5 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
6 NAME Character(50) VARCHAR2(50) NOT NULL Name