GP_ABS_SECDEFN

(SQL Table)
 Index Back

Template Section Setup Table

Configurable Sections: The AbsenceTemplate Section Setup Table is where the meta-data for each template section is stored.

  • Related Language Record: GP_ABS_SECD_LNG

  • Parent Record Of GP_ABS_HDR_LNG GP_ABS_SECDTL GP_ABS_SECD_LNG

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

    Prompt Table: GP_COUNTRY

    2 GP_ABS_CS_SEC_ID Character(18) VARCHAR2(18) NOT NULL Template Section ID
    3 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

    Default Value: 1

    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    6 DESCRLONG Long Character CLOB Long Description
    7 GP_ABS_CS_PRODUCT Character(2) VARCHAR2(2) NOT NULL Configurable Sections Setup: Section product.
    BA=Benefits Administration
    EG=Education and Government
    GA=Absence Management
    GP=Global Payroll
    TL=Time and Labor
    8 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID

    Prompt Table: GP_ABS_APCLS_VW

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

    Prompt Table: GP_ABS_APPTH_VW

    10 METHODNAME Character(32) VARCHAR2(32) NOT NULL Method Name
    11 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N

    12 GP_ABS_EFFDT_ENBL Character(1) VARCHAR2(1) NOT NULL Effective Date Enable

    Default Value: N

    13 GP_ABS_COPY_PREV Character(1) VARCHAR2(1) NOT NULL Copy Previous Row

    Default Value: N

    14 GP_ABS_EDIT_ROW Character(1) VARCHAR2(1) NOT NULL Edit Row Enable

    Default Value: N

    15 GP_ABS_ADD_ROW Character(1) VARCHAR2(1) NOT NULL Add Row Enable

    Default Value: N