SCC_STG_CONS_V2

(SQL View)
 Index Back

Constituent Stage SearchRecord

Constituent Staging Search Record that joins to a security view

SELECT SEC.OPRID , STG.SCC_TEMP_ID , STG.SCC_TRANSAC_CD ,%DatePart(STG.CREATED_DTTM ) , STG.SCC_STG_STATUS , XLAT.XLATLONGNAME , NAM.LAST_NAME_SRCH , NAM.FIRST_NAME_SRCH , NAM.FIRST_NAME , NAM.LAST_NAME , NAM.NAME , STG.EMPLID , STG.USERID FROM PS_SCC_STG_CONSTIT STG , PSXLATITEM XLAT , PS_SCC_STG_NAMES NAM , PS_SCC_SL_TRNMAP MAP , PS_SCC_TRN_SCTY_VW SEC WHERE XLAT.FIELDVALUE = STG.SCC_STG_STATUS AND XLAT.FIELDNAME = 'SCC_STG_STATUS' AND %EffdtCheck(PSXLATITEM XLAT2,XLAT,%currentdatein) AND NAM.SCC_TEMP_ID = STG.SCC_TEMP_ID AND NAM.NAME_TYPE = 'PRI' AND MAP.SCC_TEMP_ID = STG.SCC_TEMP_ID AND SEC.SCC_TRANSAC_CD = MAP.SCC_TRANSAC_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 SCC_TEMP_ID Number(16,0) DECIMAL(16) NOT NULL Temporary ID

Prompt Table: SCC_STG_CONS_V2

3 SCC_TRANSAC_CD Character(25) VARCHAR2(25) NOT NULL Transaction

Prompt Table: SCC_TRN_SCTY_VW

4 SCC_STG_CRETEDDT Date(10) DATE Created Date
5 SCC_STG_STATUS Character(2) VARCHAR2(2) NOT NULL Constituent Status
AN=Add New ID
CN=Cancelled
LD=Loaded
SA=New ID Created
SI=Ignore
SS=Suspended
SU=ID Updated
UE=Update ID
VE=Error
6 SCC_STG_LONG Character(30) VARCHAR2(30) NOT NULL Status Long XLAT description
7 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
8 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
9 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
10 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
11 NAME Character(50) VARCHAR2(50) NOT NULL Name
12 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: SCC_STGE_VW

13 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID

Prompt Table: SCC_STGU_VW