HCSCM_MSKPRM(SQL Table) |
Index Back |
|---|---|
Mask parameters for component |
| # | 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 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type Code
N=Customer Data S=Sample Data Y=System Data Default Value: Y |