RF_AG_LINE_ENTL

(SQL Table)
 Index Back

Agreement Line Entitlements

Lists all Entitlements per Agreement Line (child of Agreement Line)

  • Related Language Record: RF_AG_LNENT_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Default Value: OPR_DEF_TBL_RB.SETID

    Prompt Table: SP_SETID_NONVW

    2 AGREEMENT_CODE Character(30) VARCHAR2(30) NOT NULL This field represents the agreement code (name) for an agreement
    3 AGR_RENEWAL_NUM Number(4,0) SMALLINT NOT NULL This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal)
    4 AGREEMENT_LINE Character(10) VARCHAR2(10) NOT NULL This field records the value for the agreement line number
    5 ENTITLE_NAME Character(10) VARCHAR2(10) NOT NULL This field represents the name of the entitlement

    Prompt Table: %EDITTABLE6

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 ENTITLE_TYPE Character(4) VARCHAR2(4) NOT NULL This field represents the type of entitlement
    COV=Guaranteed Coverage
    PPM=Service Level
    RESP=Guaranteed Response
    REST=Guaranteed Restore
    8 ENTITLE_MINUTES Number(6,0) INTEGER NOT NULL This field represents the number of minutes for the response or restore time of an entitlement
    9 SERVICE_LVL_CD Character(4) VARCHAR2(4) NOT NULL This field stores the Service Level Code.
    7X24=7X24
    ENH=Enhanced
    PREF=Preferred
    PREM=Premium
    STD=Standard

    Prompt Table: RF_SERVICE_LVL
    Set Control Field: SERVICE_LVL_CD

    10 COVERAGE_TYPE Character(4) VARCHAR2(4) NOT NULL This field represents the coverage type of an entitlement
    EXP=Expenses
    MAT=Material
    TIME=Time
    11 AGRT_COV_PCT Number(3,0) SMALLINT NOT NULL This field represents the agreement coverage percentage
    12 AGRT_COV_LEN Number(6,0) INTEGER NOT NULL This field represents the agreement coverage length
    13 AGRT_COV_UOM Character(4) VARCHAR2(4) NOT NULL This field represents agreement coverage unit of measurement
    DAY=Day
    MON=Month
    WK=Week
    YR=Year
    14 ENTITLE_PCT Signed Number(4,0) DECIMAL(3) NOT NULL This field represents the entitlement uplift or discount percent
    15 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    16 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time