LM_ADHC_TBL

(SQL Table)
 Index Back

Adhoc Setup Table

Adhoc Setup Table

  • Related Language Record: LM_ADHC_LNG_TBL

  • Parent Record Of LM_ADHC_LE_TBL LM_ADHC_SEC_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_ADHC_ID Number(10,0) DECIMAL(10) NOT NULL Adhoc Id

    Default Value: 9999999999

    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 LM_ALW_FLD_FOUR Character(1) VARCHAR2(1) NOT NULL Free Field Four

    Y/N Table Edit

    Default Value: N

    4 LM_ALW_FLD_ONE Character(1) VARCHAR2(1) NOT NULL Free Field One

    Y/N Table Edit

    Default Value: N

    5 LM_ALW_FLD_THREE Character(1) VARCHAR2(1) NOT NULL Free Field Three

    Y/N Table Edit

    Default Value: N

    6 LM_ALW_FLD_TWO Character(1) VARCHAR2(1) NOT NULL Free Field Two

    Y/N Table Edit

    Default Value: N

    7 LM_FLD_FOUR_REQ Character(1) VARCHAR2(1) NOT NULL Field Four

    Y/N Table Edit

    Default Value: N

    8 LM_FLD_ONE_REQ Character(1) VARCHAR2(1) NOT NULL Field one

    Y/N Table Edit

    Default Value: N

    9 LM_FLD_THREE_REQ Character(1) VARCHAR2(1) NOT NULL Field Three

    Y/N Table Edit

    Default Value: N

    10 LM_FLD_TWO_REQ Character(1) VARCHAR2(1) NOT NULL Field Two

    Y/N Table Edit

    Default Value: N

    11 LM_ALW_CURR_LKP Character(1) VARCHAR2(1) NOT NULL Allow Currency Look up

    Y/N Table Edit

    12 LM_ALW_EU Character(1) VARCHAR2(1) NOT NULL Allow Education units

    Y/N Table Edit

    13 LM_ALW_PRICE Character(1) VARCHAR2(1) NOT NULL Allow Price

    Y/N Table Edit

    14 LM_ST_DT_REQ Character(1) VARCHAR2(1) NOT NULL Required

    Y/N Table Edit

    15 LM_END_EFFDT Date(10) DATE The end effective date, automatically maintained, there's a doc on how this works, so read it
    16 LM_ALW_TITLE Character(1) VARCHAR2(1) NOT NULL Title

    Y/N Table Edit

    Default Value: N

    17 LM_TITLE_REQ Character(1) VARCHAR2(1) NOT NULL Required

    Y/N Table Edit

    18 LM_ACTIVE Character(1) VARCHAR2(1) NOT NULL Active
    N=Inactive
    Y=Active
    19 LM_ADHC_TYPE Character(30) VARCHAR2(30) NOT NULL Type
    20 LM_ADHC_APRVL_INT Character(30) VARCHAR2(30) NOT NULL Adhoc internal approval types
    10=None
    20=Standard
    50=Learner Selected

    Default Value: NONE

    Prompt Table: LM_ADH_PRCSD_VW

    21 LM_ADHC_APRVL_EXT Character(4) VARCHAR2(4) NOT NULL Adhoc External Approval Types
    10=None
    40=Admin
    50=Learner Selected

    Default Value: 10

    22 LM_CURR_LKP_REQ Character(1) VARCHAR2(1) NOT NULL Required

    Y/N Table Edit

    23 LM_DESCR_REQ Character(1) VARCHAR2(1) NOT NULL Required

    Y/N Table Edit

    24 LM_ED_DT_REQ Character(1) VARCHAR2(1) NOT NULL Required

    Y/N Table Edit

    25 LM_ENRLMT_ADMIN_ID Number(15,0) DECIMAL(15) NOT NULL Enrollment Administrator ID

    Prompt Table: LM_PERS_NAME_VW

    26 LM_EU_REQ Character(1) VARCHAR2(1) NOT NULL Required

    Y/N Table Edit

    27 LM_INST_REQ Character(1) VARCHAR2(1) NOT NULL Required

    Y/N Table Edit

    28 LM_INSTRUCTIONS Character(250) VARCHAR2(250) NOT NULL Instructions
    29 LM_LOC_REQ Character(1) VARCHAR2(1) NOT NULL Required

    Y/N Table Edit

    30 LM_OWNER_ID Number(15,0) DECIMAL(15) NOT NULL Owner ID

    Prompt Table: LM_PERS_NAME_VW

    31 LM_PRVD_BY_REQ Character(1) VARCHAR2(1) NOT NULL Required

    Y/N Table Edit

    32 LM_PRICE_REQ Character(1) VARCHAR2(1) NOT NULL Required

    Y/N Table Edit

    33 LM_STD_HRS_REQ Character(1) VARCHAR2(1) NOT NULL Required

    Y/N Table Edit

    34 LM_SUP_BY_REQ Character(1) VARCHAR2(1) NOT NULL Required

    Y/N Table Edit

    35 LM_TRVL_HRS_REQ Character(1) VARCHAR2(1) NOT NULL Required

    Y/N Table Edit

    36 LM_ALW_CI Character(1) VARCHAR2(1) NOT NULL Equivalent Activities

    Y/N Table Edit

    37 LM_ALW_DESCR Character(1) VARCHAR2(1) NOT NULL Description

    Y/N Table Edit

    38 LM_ALW_ED_DT Character(1) VARCHAR2(1) NOT NULL Display

    Y/N Table Edit

    39 LM_ALW_INST Character(1) VARCHAR2(1) NOT NULL Institution

    Y/N Table Edit

    40 LM_ALW_LOC Character(1) VARCHAR2(1) NOT NULL Location

    Y/N Table Edit

    41 LM_ALW_OBJ Character(1) VARCHAR2(1) NOT NULL Equivalent Objectives

    Y/N Table Edit

    42 LM_ALW_PRG Character(1) VARCHAR2(1) NOT NULL Equivalent Programs

    Y/N Table Edit

    43 LM_ALW_PRVD_BY Character(1) VARCHAR2(1) NOT NULL Display

    Y/N Table Edit

    44 LM_ALW_ST_DT Character(1) VARCHAR2(1) NOT NULL Display

    Y/N Table Edit

    45 LM_ALW_STD_HRS Character(1) VARCHAR2(1) NOT NULL Display

    Y/N Table Edit

    46 LM_ALW_SUP_BY Character(1) VARCHAR2(1) NOT NULL Display

    Y/N Table Edit

    47 LM_ALW_TRVL_HRS Character(1) VARCHAR2(1) NOT NULL Display

    Y/N Table Edit

    48 LM_FLD_ONE_TXT Character(30) VARCHAR2(30) NOT NULL Custom Label one
    49 LM_FLD_TWO_TXT Character(30) VARCHAR2(30) NOT NULL Custom Label one
    50 LM_FLD_THREE_TXT Character(30) VARCHAR2(30) NOT NULL Custom Label one
    51 LM_FLD_FOUR_TXT Character(30) VARCHAR2(30) NOT NULL Custom Label one
    52 LM_DIFELIGIBLE_FLG Character(1) VARCHAR2(1) NOT NULL Eligible to DIF

    Y/N Table Edit

    Default Value: N

    53 LM_INT_APPR_ID Number(15,0) DECIMAL(15) NOT NULL Approver ID field

    Prompt Table: LM_ADHC_APPR_VW

    54 LM_EXT_APPR_ID Number(15,0) DECIMAL(15) NOT NULL Approver ID field

    Prompt Table: LM_EXT_APRR_VW