SDK_BUS_EXP_PER

index back

SDK Business Expense Periods

SDK Business Expense Periods

  • Parent record: SDK_PERS_DATA
  • PeopleSoft Field NameField TypeColumn TypeDescription
    SDK_EMPLIDCharacter(11)VARCHAR2(11) NOT NULLSDK Employee ID

    Prompt Table: SDK_PERS_DATA

    SYNCIDNumber(10,0)DECIMAL(10) NOT NULLThe 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.
    SDK_SYNCTIMESTAMPDateTime(26)TIMESTAMPSDK Synchronization Timestamp
    SDK_EXP_PER_DTDate(10)DATE NOT NULLSDK Expense Period Date
    SDK_SUBMIT_FLGCharacter(1)VARCHAR2(1) NOT NULLSDK Submit Flag

    Y/N Table Edit

    Default: N

    SDK_INTL_FLGCharacter(1)VARCHAR2(1) NOT NULLSDK International Flag

    Default: N

    Prompt Table: SDK_INTL_FLG_CD

    SDK_APPR_STATUSCharacter(1)VARCHAR2(1) NOT NULLSDK Approval status flag used on appr_inst_log and derived records to track virtual approver status
    A=Approved
    D=Denied
    P=Pending

    Default: P

    SDK_APPR_INSTANCENumber(9,0)DECIMAL(9) NOT NULLSDK Unique number for each runtime occurrence of a virtual approver process
    SDK_DESCRCharacter(30)VARCHAR2(30) NOT NULLSDK Description
    SDK_COMMENTSLong CharacterCLOBSDK Comments
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19