| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PNLGRPNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Component Name
Prompt Table:
PSPNLGRPNAME_VW
|
| 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
Default Value: STD
|
| 4 |
SEQUENCE_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 5 |
EOCC_SEQUENCE_NBR |
Number(4,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 6 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 7 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 8 |
OCCURSLEVEL |
Number(1,0) |
SMALLINT NOT NULL |
Occurs level
|
| 9 |
RECNAME1 |
Character(15) |
VARCHAR2(15) NOT NULL |
Record Name 1
|
| 10 |
FIELDNAME1 |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name 1
|
| 11 |
SECOCCURSLEVEL |
Number(1,0) |
SMALLINT NOT NULL |
Stores the page field level relative to secondary page
|
| 12 |
LBLTEXT |
Character(60) |
VARCHAR2(60) NOT NULL |
Label Text
|
| 13 |
PNLNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Page Name (see PSPNLDEFN).
|
| 14 |
STDPNLNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Page Name
|
| 15 |
PTCS_PNLFLDNAME |
Character(254) |
VARCHAR2(254) NOT NULL |
Page Field Name
|
| 16 |
EOCC_LBL_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
label Override
|
| 17 |
EOCC_IS_REQUIRED |
Character(1) |
VARCHAR2(1) NOT NULL |
Is this required field?
Default Value: N
|
| 18 |
EOCC_SET_BLANK |
Character(1) |
VARCHAR2(1) NOT NULL |
Set Value to Blank
|
| 19 |
EOCC_DFLT_VALUE |
Character(40) |
VARCHAR2(40) NOT NULL |
Default Value
|
| 20 |
EOCC_VISIBLE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Is field Visible?
N=No
Y=Yes
Default Value: Y
|
| 21 |
EOCC_MASK_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Is field Visible?
N=No
Y=Yes
Default Value: N
|
| 22 |
EOCC_DISABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Disbale the field.
N=No
Y=Yes
Default Value: N
|
| 23 |
FIELDTYPE |
Number(2,0) |
SMALLINT NOT NULL |
Field Type (from PSST0101 Ref.)
|
| 24 |
FIELDUSE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Panel Field Use
|
| 25 |
EOCC_FIELD_TYPE |
Number(2,0) |
SMALLINT NOT NULL |
Field Type
|
| 26 |
EOCC_SBP_LEVEL |
Number(1,0) |
SMALLINT NOT NULL |
Subpage Level
|
| 27 |
RECNAME_BASE |
Character(15) |
VARCHAR2(15) NOT NULL |
Base record name
|
| 28 |
EOCC_FIELD_ORIGIN |
Character(4) |
VARCHAR2(4) NOT NULL |
Field Type
PMPT=Prompt Record
SEC=Secondary Page via PC
SRCH=Search Record
STD=Standard
Default Value: STD
|
| 29 |
EOCC_MASK_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Mask ID
Prompt Table:
EOCC_FIELDS_DVW
|
| 30 |
PTAI_SYSTEM_DATA |
Character(1) |
VARCHAR2(1) NOT NULL |
Option to mark the AG template as System delivered data.
Default Value: N
|
| 31 |
EOCC_PROF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Profile Status
C=Changed
D=Default
Default Value: D
|
| 32 |
EOCC_MASK_SEP |
Character(1) |
VARCHAR2(1) NOT NULL |
Mask Separator
Y/N Table Edit
|
| 33 |
EOCC_MASK_CHAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Mask character
*=*
X=X
|
| 34 |
EOCC_MASK_TRAILNUM |
Number(1,0) |
SMALLINT NOT NULL |
Number of trailing character
|
| 35 |
EOCC_MASK_DAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Mask Day
Y/N Table Edit
|
| 36 |
EOCC_MASK_MONTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Mask Month
Y/N Table Edit
|
| 37 |
EOCC_MASK_YEAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Mask Year
Y/N Table Edit
|
| 38 |
EOCC_CHGTRK_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Change Tracking
N=No
Y=Yes
Default Value: Y
|