HCSCM_MSKPRM_VW

(SQL View)
 Index Back

Mask parameters for component

Data Masking: Masking Parameters View. Union of HCSCM_MSKPRM and HCSCM_MSKPRM_DP

SELECT PNLGRPNAME , HCSCM_FLD_GRP , SEQNO , HCSCM_NIDMASK_FMT , HCSCM_DOB_FMT , HCSCM_ACNO_DGT , HCSCM_CNTRY_REC , HCSCM_CNTRY_FLD , HCSCM_NIDTYPE_REC , HCSCM_NIDTYPE_FLD , HCSCM_NID_REC , HCSCM_NID_FLD , HCSCM_DOB_REC , HCSCM_DOB_FLD , HCSCM_ACCNUM_REC , HCSCM_ACCNUM_FLD , ' ' , ' ' , ' ' , ' ' , DATA_TYPE_CD FROM PS_HCSCM_MSKPRM UNION SELECT PNLGRPNAME , HCSCM_FLD_GRP , SEQNO , ' ' , ' ' , 0 , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , HCSCM_PASS_REC , HCSCM_PASS_FLD , HCSCM_DL_REC , HCSCM_DL_FLD , DATA_TYPE_CD FROM PS_HCSCM_MSKPRM_DP

  • Audit Record: AUDIT_HCSCM_PRM

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

    Prompt Table: PSPNLGRPDEFN

    2 HCSCM_FLD_GRP Character(4) VARCHAR2(4) NOT NULL Field Group
    3 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
    4 HCSCM_NIDMASK_FMT Character(30) VARCHAR2(30) NOT NULL Masking Format for National ID type
    5 HCSCM_DOB_FMT Character(4) VARCHAR2(4) NOT NULL Masking Format
    FULL=Complete
    YEAR=Year
    6 HCSCM_ACNO_DGT Number(2,0) SMALLINT NOT NULL Number of unmasked digits

    Default Value: 4

    7 HCSCM_CNTRY_REC Character(15) VARCHAR2(15) NOT NULL Country Record Name

    Prompt Table: PSRECDEFN

    8 HCSCM_CNTRY_FLD Character(18) VARCHAR2(18) NOT NULL Country Field Name

    Prompt Table: HCSCM_RCFLD_DVW

    9 HCSCM_NIDTYPE_REC Character(15) VARCHAR2(15) NOT NULL NID Type Record

    Prompt Table: PSRECDEFN

    10 HCSCM_NIDTYPE_FLD Character(18) VARCHAR2(18) NOT NULL NID Type Field

    Prompt Table: HCSCM_RCFLD_DVW

    11 HCSCM_NID_REC Character(15) VARCHAR2(15) NOT NULL NID Rec Name

    Prompt Table: PSRECDEFN

    12 HCSCM_NID_FLD Character(18) VARCHAR2(18) NOT NULL NID Field Name

    Prompt Table: HCSCM_RCFLD_DVW

    13 HCSCM_DOB_REC Character(15) VARCHAR2(15) NOT NULL Birthdate Record

    Prompt Table: PSRECDEFN

    14 HCSCM_DOB_FLD Character(18) VARCHAR2(18) NOT NULL Birthdate Field

    Prompt Table: HCSCM_RCFLD_DVW

    15 HCSCM_ACCNUM_REC Character(15) VARCHAR2(15) NOT NULL Account Number Record

    Prompt Table: PSRECDEFN

    16 HCSCM_ACCNUM_FLD Character(18) VARCHAR2(18) NOT NULL Account Number Field

    Prompt Table: HCSCM_RCFLD_DVW

    17 HCSCM_PASS_REC Character(15) VARCHAR2(15) NOT NULL Data Masking: Passport Number Record

    Prompt Table: PSRECDEFN

    18 HCSCM_PASS_FLD Character(18) VARCHAR2(18) NOT NULL Data Masking: Passport Number Field

    Prompt Table: HCSCM_RCFLD_DVW

    19 HCSCM_DL_REC Character(15) VARCHAR2(15) NOT NULL Data Masking: Driver's License Number Record

    Prompt Table: PSRECDEFN

    20 HCSCM_DL_FLD Character(18) VARCHAR2(18) NOT NULL Data Masking: Driver's License Number Field

    Prompt Table: HCSCM_RCFLD_DVW

    21 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: Y