EOCC_MASK_PROF

(SQL Table)
Index Back

Mask Profile

Mask Profile

  • Related Language Record: EOCC_MSKPRF_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOCC_MASK_ID Character(15) VARCHAR2(15) NOT NULL Mask ID
    2 EOCC_MSK_SHRTDESCR Character(10) VARCHAR2(10) NOT NULL Mask Short description
    3 EOCC_MASK_DESCR Character(30) VARCHAR2(30) NOT NULL Mask description
    4 EOCC_MASK_TYPE Character(1) VARCHAR2(1) NOT NULL Mask Type
    C=Complete
    D=Date
    S=Setup Table Based
    T=Unmask Trailing Characters

    Default Value: C

    5 EOCC_MASK_SEP Character(1) VARCHAR2(1) NOT NULL Mask Separator

    Y/N Table Edit

    Default Value: Y

    6 EOCC_MASK_CHAR Character(1) VARCHAR2(1) NOT NULL Mask character
    *=*
    X=X

    Default Value: X

    7 EOCC_MASK_TRAILNUM Number(1,0) SMALLINT NOT NULL Number of trailing character
    8 EOCC_MASK_DAY Character(1) VARCHAR2(1) NOT NULL Mask Day

    Y/N Table Edit

    Default Value: N

    9 EOCC_MASK_MONTH Character(1) VARCHAR2(1) NOT NULL Mask Month

    Y/N Table Edit

    Default Value: N

    10 EOCC_MASK_YEAR Character(1) VARCHAR2(1) NOT NULL Mask Year

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: PSRECDEFN_VW

    12 EOCC_MASK_FMT_FLD Character(18) VARCHAR2(18) NOT NULL Mask Format Field

    Prompt Table: EOCC_RECFLD_VW
    Set Control Field: RECNAME

    13 DEFAULT_FLG Character(1) VARCHAR2(1) NOT NULL Default Flag