LM_ADHC_DTLS_VW

(SQL View)
 Index Back

Adhoc Setup View

Adhoc Setup View

SELECT LM_ADHC_ID , EFFDT , LM_ALW_FLD_FOUR , LM_ALW_FLD_ONE , LM_ALW_FLD_THREE , LM_ALW_FLD_TWO , LM_FLD_FOUR_REQ , LM_FLD_ONE_REQ , LM_FLD_THREE_REQ , LM_FLD_TWO_REQ , LM_ALW_CURR_LKP , LM_ALW_EU , LM_ALW_PRICE , LM_ST_DT_REQ , LM_END_EFFDT , LM_ALW_TITLE , LM_TITLE_REQ , LM_ACTIVE , LM_ADHC_TYPE , LM_ADHC_APRVL_EXT , LM_ADHC_APRVL_INT , LM_CURR_LKP_REQ , LM_DESCR_REQ , LM_ED_DT_REQ , LM_ENRLMT_ADMIN_ID , LM_EU_REQ , LM_INST_REQ , LM_INSTRUCTIONS , LM_LOC_REQ , LM_OWNER_ID , LM_PRVD_BY_REQ , LM_PRICE_REQ , LM_STD_HRS_REQ , LM_SUP_BY_REQ , LM_TRVL_HRS_REQ , LM_ALW_CI , LM_ALW_DESCR , LM_ALW_ED_DT , LM_ALW_INST , LM_ALW_LOC , LM_ALW_OBJ , LM_ALW_PRG , LM_ALW_PRVD_BY , LM_ALW_ST_DT , LM_ALW_STD_HRS , LM_ALW_SUP_BY , LM_ALW_TRVL_HRS , LM_FLD_ONE_TXT , LM_FLD_TWO_TXT , LM_FLD_THREE_TXT , LM_FLD_FOUR_TXT FROM PS_LM_ADHC_TBL

  • Related Language Record: LM_ADHC_LNG_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
    4 LM_ALW_FLD_ONE Character(1) VARCHAR2(1) NOT NULL Free Field One
    5 LM_ALW_FLD_THREE Character(1) VARCHAR2(1) NOT NULL Free Field Three
    6 LM_ALW_FLD_TWO Character(1) VARCHAR2(1) NOT NULL Free Field Two
    7 LM_FLD_FOUR_REQ Character(1) VARCHAR2(1) NOT NULL Field Four
    8 LM_FLD_ONE_REQ Character(1) VARCHAR2(1) NOT NULL Field one
    9 LM_FLD_THREE_REQ Character(1) VARCHAR2(1) NOT NULL Field Three
    10 LM_FLD_TWO_REQ Character(1) VARCHAR2(1) NOT NULL Field Two
    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

    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_EXT Character(4) VARCHAR2(4) NOT NULL Adhoc External Approval Types
    10=None
    40=Admin
    50=Learner Selected
    21 LM_ADHC_APRVL_INT Character(30) VARCHAR2(30) NOT NULL Adhoc internal approval types
    10=None
    20=Standard
    50=Learner Selected
    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_PERSON

    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_PERSON

    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