EOCC_EDIT_MASK(SQL Table) |
Index Back |
---|---|
Edit Mask ProfileEdit Mask Profile |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL | Component Name |
2 | MARKET | Character(3) | VARCHAR2(3) NOT NULL | Market |
3 | EOCC_CONFIG_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Configuration type
MASK=Masking STD=Standard TRK=Change Tracking |
4 | EOCC_SEQUENCE_NBR | Number(4,0) | SMALLINT NOT NULL | Sequence Number |
5 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN_VW |
6 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
7 | OCCURSLEVEL | Number(1,0) | SMALLINT NOT NULL | Occurs level |
8 | RECNAME1 | Character(15) | VARCHAR2(15) NOT NULL | Record Name 1 |
9 | FIELDNAME1 | Character(18) | VARCHAR2(18) NOT NULL | Field Name 1 |
10 | EOCC_MASK_ID | Character(15) | VARCHAR2(15) NOT NULL | Mask ID |
11 | EOCC_MASK_CNTL_FLD | Character(18) | VARCHAR2(18) NOT NULL |
Mask Control Field
Prompt Table: EOCC_RECFLD_VW |
12 | SEQUENCE_NBR | Number(2,0) | SMALLINT NOT NULL | Sequence Number |
13 | RECNAME_1 | Character(15) | VARCHAR2(15) NOT NULL |
Record 1 Name
Prompt Table: PSRECDEFN_VW |
14 | EOCC_MSK_COMP_REC | Character(15) | VARCHAR2(15) NOT NULL |
Mask Component Record Name
Prompt Table: PSRECDEFN_VW |
15 | EOCC_MSK_COMP_FLD | Character(18) | VARCHAR2(18) NOT NULL |
Mask Component Record Name
Prompt Table:
EOCC_MASKREC_VW
|