VAT_CNTXT_NF_VW(SQL View) |
Index Back |
|---|---|
Context Default no VAT_FIELDSThis view joins VAT Context Detail Line with the VAT Fields to give a comprehensive view of each Context VAT field, when there is no VAT_FIELDS row. This view is used by LC_VAT:Context app class to populate the Context Field rowset. |
| SELECT %subrec(VAT_CNTXT_SBR, A) , 'N' FROM PS_VAT_CNTXT_DTL A WHERE NOT EXISTS ( SELECT 1 FROM PS_VAT_FIELDS F WHERE F.FIELDNAME = A.FIELDNAME) |
| # | 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 |
| 13 | VAT_DEFAULT_USAGE | Character(1) | VARCHAR2(1) NOT NULL |
VAT Defaulting Usage
C=Control H=Handling N=None S=Services |