HR_MSS_CT_SEQVW

(SQL View)
 Index Back

Compound Transactions Sequence


SELECT A.HR_MSS_CT_NAME , A.EFFDT , A.REG_REGION , A.SEQUENCE , A.OBJECTOWNERID , A.HR_SSTEXT_SUB_ID , A.TEXT_ID , A.TEXT_ID2 , B.HR_SSTEXT_TEXT , A.ACTION , A.ACTION_REASON , A.HIDE_REASON_FLG , A.PNLNAME , A.DEFAULT_FLAG , A.HIDDEN_FLAG , A.REASON_REQ_FLG FROM PS_HR_MSS_CT_SEQ A , PS_HR_SSTEXT_TXTVW B WHERE A.OBJECTOWNERID=B.OBJECTOWNERID AND A.HR_SSTEXT_SUB_ID=B.HR_SSTEXT_SUB_ID AND A.TEXT_ID=B.TEXT_ID AND A.EFFDT = ( SELECT MAX (C.EFFDT ) FROM PS_HR_MSS_CT_CFG C WHERE A.HR_MSS_CT_NAME=C.HR_MSS_CT_NAME AND C.STATUS='A' AND C.REG_REGION = A.REG_REGION) AND %EffdtCheck(HR_SSTEXT_TXTVW SSTEXT, B, %CurrentDateIn)

  • Parent record: HR_MSS_CT_CFG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HR_MSS_CT_NAME Character(25) VARCHAR2(25) NOT NULL Compound Transaction Name
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
    4 SEQUENCE Number(2,0) SMALLINT NOT NULL Chartfield Sequence
    5 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    6 HR_SSTEXT_SUB_ID Character(4) VARCHAR2(4) NOT NULL The Sub ID is field that is optionally used to further partition Text Catalog entries within an Object Owner ID. For example, we might want to create a Sub ID to keep Text Catalog entries for Enrollment separate from the Text Catalog entries for the inquiry pages within the eBenefits ObjectOwnerId.
    7 TEXT_ID Character(18) VARCHAR2(18) NOT NULL Text ID

    Prompt Table: HR_SSTEXT_TX_VW

    8 TEXT_ID2 Character(18) VARCHAR2(18) NOT NULL Text ID
    9 HR_SSTEXT_TEXT Long Character(8095) CLOB Long Text field for HR Self-Service Text Catalog. This is the text that is displayed on a page from the Text Catalog.
    10 ACTION Character(3) VARCHAR2(3) NOT NULL Action

    Prompt Table: HR_MSS_CT_ACTN

    11 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

    Prompt Table: ACTN_REASON_VW
    Set Control Field: ACTION

    12 HIDE_REASON_FLG Character(1) VARCHAR2(1) NOT NULL Hide Action Reason flag

    Y/N Table Edit

    Default Value: N

    13 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).

    Prompt Table: PSPNLDEFN_VW

    14 DEFAULT_FLAG Character(1) VARCHAR2(1) NOT NULL Set As Default
    N=No
    Y=Yes

    Default Value: N

    15 HIDDEN_FLAG Character(1) VARCHAR2(1) NOT NULL Hidden Flag

    Y/N Table Edit

    Default Value: N

    16 REASON_REQ_FLG Character(1) VARCHAR2(1) NOT NULL Action Reason Required flag