WCS_ECM_WD_SRCH

(SQL View)
 Index Back

Comp Cycle Worker Det Search

Compensation Cycle Manage Worker Detail Search Record

SELECT NSTS.BUDGET_ID , NSTS.BUDGET_START_DT , NSTS.TREE_NODE_NUM , CFG.DESCR , CFG.DESCR20 , DMG.EMPLID , DMG.EMPL_RCD , ACSS.EMPLID , NM.NAME_PSFORMAT , NM.LAST_NAME_SRCH , NM.FIRST_NAME_SRCH , NM.NAME_AC , NM.MIDDLE_NAME , CFG.BUDGET_END_DT FROM PS_WCS_ECM_NOD_STS NSTS , PS_WCS_ECM_CYC_CFG CFG , PS_WCS_ECM_EE_DMG DMG , PS_PERSON_NAME NM , PS_WCS_ECM_ACCESS ACSS WHERE NSTS.BUDGET_ID = CFG.BUDGET_ID AND NSTS.BUDGET_START_DT = CFG.BUDGET_START_DT AND CFG.BUDGET_ID = DMG.BUDGET_ID AND CFG.BUDGET_START_DT = DMG.BUDGET_START_DT AND NSTS.TREE_NODE_NUM = DMG.TREE_NODE_NUM AND DMG.EMPLID = NM.EMPLID AND (CFG.WCS_CYCLE_STATUS = 'BLT' OR CFG.WCS_CYCLE_STATUS = 'CAN') AND ACSS.BUDGET_ID = CFG.BUDGET_ID AND ACSS.BUDGET_START_DT = CFG.BUDGET_START_DT AND ACSS.WCS_SP_ACCESS_TYPE = 'C' AND ACSS.TREE_NODE_NUM = 1

  • Related Language Record: WCS_ECM_WD_SLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUDGET_ID Character(10) VARCHAR2(10) NOT NULL Budget ID
    2 BUDGET_START_DT Date(10) DATE NOT NULL Budget Start Date
    3 TREE_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description
    6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    7 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    8 EMPLID_ASSIGN_TO Character(11) VARCHAR2(11) NOT NULL Used for Interest List to determine who the Profile is assigned to
    9 NAME Character(50) VARCHAR2(50) NOT NULL Name
    10 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    11 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    12 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
    13 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
    14 BUDGET_END_DT Date(10) DATE Budget End Date