FIN_ATTRIBUTES

(SQL Table)
 Index Back

Attribute Table

Generic Attribute Table keyed by Component Name for setup type of information.

  • Parent Record Of FIN_ATTRIB_VAL FIN_ATTRVAL_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

    Prompt Table: FIN_PNLGRP_VW

    2 ATTRIBUTE_ID Character(20) VARCHAR2(20) NOT NULL Attribute ID
    3 ENABLED Character(1) VARCHAR2(1) NOT NULL A flag indicates whether this row is enabled or not.

    Y/N Table Edit

    Default Value: Y

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 MULTIPLE_FLG Character(1) VARCHAR2(1) NOT NULL Allow Multiple Values per Attr

    Y/N Table Edit

    Default Value: N

    6 REQUIRED_FLAG Character(1) VARCHAR2(1) NOT NULL Required Flag
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    7 DESCRLONG Long Character CLOB Long Description