HR_MSS_CT_POS_V

(SQL View)
 Index Back

Guided Self Service Fields

Position Data Fields

SELECT DISTINCT A.HR_MSS_CT_NAME , A.REG_REGION , A.EFFDT , A.RECNAME , B.FIELDNAME , A.LBLTEXT , A.INCLUDE_FLG , A.DISPLAY_FLG , A.SYSTEM_DATA_FLG FROM PS_HR_MSS_CT_FLDS A , PSRECFIELD B WHERE B.RECNAME = 'POSITION_DATA' AND A.FIELDNAME = B.FIELDNAME AND A.INCLUDE_FLG = 'Y' AND A.DISPLAY_FLG = 'N'

  • 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

    Default Value: HR_MSS_CT_SEQ.HR_MSS_CT_NAME

    2 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

    Default Value: HR_MSS_CT_SEQ.REG_REGION

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: HR_MSS_CT_SEQ.EFFDT

    4 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFN_VW

    5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: PSRECFIELD_VW
    Set Control Field: RECNAME

    6 LBLTEXT Character(60) VARCHAR2(60) NOT NULL Label Text
    7 INCLUDE_FLG Character(1) VARCHAR2(1) NOT NULL Visible

    Y/N Table Edit

    Default Value: N

    8 DISPLAY_FLG Character(1) VARCHAR2(1) NOT NULL Display Only Flag

    Y/N Table Edit

    Default Value: N

    9 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.

    Y/N Table Edit

    Default Value: N