ALLOC_OFFV_TBL

(SQL Table)
Index Back

Allocation Offset CF Values

  • Parent record: ALLOC_STEP_TBL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 PROCESS_STEP Character(10) VARCHAR2(10) NOT NULL Process Step
    3 VERSION_NUM Number(3,0) SMALLINT NOT NULL Version Number
    4 EFFDT Date(10) DATE NOT NULL Effective Date
    5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: %EDITTABLE14

    6 FIELD_SOURCE Character(4) VARCHAR2(4) NOT NULL Field source
    B=Basis
    D=Begin Pd
    E=End Period
    F=Value
    G=Group by
    J=Seq Num
    P=Pool
    R=Req Date
    7 FIELD_VALUE Character(30) VARCHAR2(30) NOT NULL Field Value

    Prompt Table: %EDITTABLE

    8 CHARGE_FIELD Character(18) VARCHAR2(18) NOT NULL Field Mapping

    Prompt Table: RECFLD_LBL_VW