LM_ADHC_TBL(SQL Table) |
Index Back |
---|---|
Adhoc Setup TableAdhoc Setup Table |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Number(10,0) | DECIMAL(10) NOT NULL |
Adhoc Id
Default Value: 9999999999 |
|
2 | 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 |