EOCC_MASK_PROF(SQL Table) |
Index Back |
---|---|
Mask ProfileMask Profile |
# | 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
|
13 | DEFAULT_FLG | Character(1) | VARCHAR2(1) NOT NULL | Default Flag |