VAT_CNTXT_DTL_D(SQL Table) |
Index Back |
|---|---|
VAT Context Dtl - Driver FldsWork Scroll for Driver derived Output Fields |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  VAT_CONTEXT_ID |
Character(30) | VARCHAR2(30) NOT NULL | VAT Context ID |
| 2 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: PSDBFIELDNAMEVW |
| 3 | SEL | Character(1) | VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit Default Value: Y |
| 4 | WRITE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Write Flag
Y/N Table Edit |
| 5 | VAT_SUBPAGE_USAGE | Character(1) | VARCHAR2(1) NOT NULL |
Common Subpage Usage
D=Display Only E=Enterable |
| 6 | VAT_FIELD_CATEGORY | Character(1) | VARCHAR2(1) NOT NULL |
VAT Field Category
C=Calculation D=Driver Default K=Driver Key O=Determinant |
| 7 | VAT_FIELDVALUE_TYP | Character(1) | VARCHAR2(1) NOT NULL |
FieldValue Subclass Type
A=ApplicationField C=AlgorithmField D=DriverField H=HardCodedValue W=WorkField |
| 8 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN |
| 9 | FIELDNAME_ALIAS | Character(30) | VARCHAR2(30) NOT NULL |
Field Name Alias
Prompt Table: PSDBFIELD |
| 10 | APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL |
Application Class ID
Prompt Table: VAT_ALGO_VW |
| 11 | REQUIRED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Required Flag
N=No Y=Yes Y/N Table Edit Default Value: N |
| 12 | SEQ_NBR_3 | Number(3,0) | SMALLINT NOT NULL | Sequence |