HCSCM_ASSOC_VW1

(SQL View)
 Index Back

Associated Field View

Data Masking: View for Assoc Fields for DOB, NID, ACCNO

SELECT PNLGRPNAME ,HCSCM_FLD_GRP ,SEQNO ,HCSCM_ASSOC_REC ,HCSCM_ASSOC_FLD ,DATA_TYPE_CD FROM PS_HCSCM_ASSOC_FLD WHERE HCSCM_FLD_GRP IN ('NID','ACNO','DOB')

  • Audit Record: AUDIT_HCSCM_ASF

    • # 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_ASSOC_REC Character(15) VARCHAR2(15) NOT NULL Associated Field Rec Name

    Prompt Table: PSRECDEFN

    5 HCSCM_ASSOC_FLD Character(18) VARCHAR2(18) NOT NULL Associated Field Field Name

    Prompt Table: HCSCM_RCFLD_DVW

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

    Default Value: Y