GP_ABS_SECDTL

(SQL Table)
 Index Back

Template Section Field Setup

Configurable Sections: The Template Section Field Setup Table, a child of the Template Section Setup Table, is where the meta-data for each field included in the section is stored.

  • Parent record: GP_ABS_SECDEFN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: GP_COUNTRY_VW

    2 GP_ABS_CS_SEC_ID Character(18) VARCHAR2(18) NOT NULL Template Section ID
    3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: GP_ABS_RCSCHVW

    4 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number

    Default Value: 1

    Prompt Table: GP_ABS_RECDEFN

    5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: GP_ABS_RCDTLVW

    6 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

    Default Value: 1

    7 GP_ABS_CS_DISPLAY Character(2) VARCHAR2(2) NOT NULL Configurable Sections Setup: Template Display type
    C=CheckBox
    D=Date
    LD=Long DropDown
    LE=Long Edit Box
    LP=Long Prompt
    SD=Short DropDown
    SE=Short Edit Box
    SP=Short Prompt

    Default Value: LE

    8 PROMPT_TABLE Character(15) VARCHAR2(15) NOT NULL Record Name

    Prompt Table: GP_ABS_RECKPVW

    9 PROMPT_FIELD Character(18) VARCHAR2(18) NOT NULL This defines what field should be used when forming a prompt for a Configurable Matrix item.

    Prompt Table: GP_ABS_PRFLDVW

    10 GP_ABS_CS_DD_IND Character(1) VARCHAR2(1) NOT NULL Configurable Section Setup: Indicates whether code, description or both are shown in a dropdown list.
    B=Code and Description
    C=Code Only
    D=Description Only

    Default Value: D

    11 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID

    Prompt Table: GP_ABS_APCLS_VW

    12 APPCLASS_PATH Character(254) VARCHAR2(254) NOT NULL Application Class Full Path

    Prompt Table: GP_ABS_APPTH_VW

    13 METHODNAME Character(32) VARCHAR2(32) NOT NULL Method Name
    14 APPCLASSID2 Character(30) VARCHAR2(30) NOT NULL Application Class ID

    Prompt Table: GP_ABS_APCL2_VW

    15 APPCLASS_PATH2 Character(254) VARCHAR2(254) NOT NULL Application Class Path

    Prompt Table: GP_ABS_APPTH_VW

    16 METHODNAME2 Character(32) VARCHAR2(32) NOT NULL Method Name
    17 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N