HR_KK_HDR

(SQL Table)
Index Back

HR Payroll Comm Cntrl Header

  • Parent Record Of HR_KK_LN_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RUN_DT Date(10) DATE Run Date
    2 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    3 KK_AMOUNT_TYPE Character(1) VARCHAR2(1) NOT NULL Commitment Control Amount Type
    0=Budget
    1=Actuals and Recognized
    2=Encumbrance
    3=Pre-Encumbrance
    4=Collected Revenue
    5=Planned
    7=Actuals, Recognize and Collect
    9=Dynamic
    4 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
    5 BUDGET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Header Status
    E=Error in Budget Check
    I=Document In Processing
    N=Not Budget Checked
    P=Provisionally Valid
    V=Valid

    Default Value: N

    6 KK_TRAN_OVER_FLAG Character(1) VARCHAR2(1) NOT NULL Commitment Control source transaction override flag
    N=No
    Y=Yes
    7 KK_TRAN_OVER_OPRID Character(30) VARCHAR2(30) NOT NULL Commitment Control source transaction override operator
    8 KK_TRAN_OVER_DTTM DateTime(26) TIMESTAMP Commitment Control source transaction override datetime
    9 IBTRANSACTIONID Character(36) VARCHAR2(36) NOT NULL Transaction ID
    10 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance