VAT_CNTXT_LN_VW

(SQL View)
Index Back

Context Default Field Details

This view joins VAT Context Detail Line with the VAT Fields to give a comprehensive view of each Context VAT field. This view is used by LC_VAT:Context app class to populate the Context Field rowset.

SELECT %subrec(VAT_CNTXT_SBR, A) , B.VAT_DEFAULT_USAGE FROM PS_VAT_CNTXT_DTL A , PS_VAT_FIELDS B WHERE A.FIELDNAME = B.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