LM_ENRLMT_IDLM_ROW_SEQPrompt Table: %EDITTABLE
Prompt Table: %EDITTABLE2
Prompt Table: %EDITTABLE3
Prompt Table: %EDITTABLE4
Prompt Table: %EDITTABLE6
Prompt Table: %EDITTABLE5
Default Value: 100
LM_CHGBK(SQL View) |
Index Back |
|---|---|
ChargeBack InfoChargeBack Info |
| SELECT CHG.LM_ENRLMT_ID ,CHG.LM_ROW_SEQ ,CHG.LM_CI_ID ,CHG.LM_ACT_ID ,CHG.LM_FUND_CODE ,CHG.LM_CLASS_FLD ,CHG.LM_PROGRAM_CODE ,CHG.LM_ACCOUNT ,CHG.LM_HR_DEPTID ,CHG.LM_PROJECT_ID ,CHG.LM_SPLIT FROM PS_LM_CHGBK_INFO CHG |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_ENRLMT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Enrollment ID |
| 2 | LM_ROW_SEQ |
Number(10,0) | DECIMAL(10) NOT NULL | Row Entry for Chart Field Split for an Enrollment |
| 3 | LM_CI_ID | Number(10,0) | DECIMAL(10) NOT NULL | Catalog Item ID - System Generated ID Number associated with each Catalog Item |
| 4 | LM_ACT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
| 5 | LM_FUND_CODE | Character(20) | VARCHAR2(20) NOT NULL |
Fund Code
Prompt Table: %EDITTABLE |
| 6 | LM_CLASS_FLD | Character(20) | VARCHAR2(20) NOT NULL |
Class Chart Field
Prompt Table: %EDITTABLE2 |
| 7 | LM_PROGRAM_CODE | Character(20) | VARCHAR2(20) NOT NULL |
Program Chart Field
Prompt Table: %EDITTABLE3 |
| 8 | LM_ACCOUNT | Character(20) | VARCHAR2(20) NOT NULL |
Account Chart Field
Prompt Table: %EDITTABLE4 |
| 9 | LM_HR_DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: %EDITTABLE6 |
| 10 | LM_PROJECT_ID | Character(20) | VARCHAR2(20) NOT NULL |
Project Chart Field
Prompt Table: %EDITTABLE5 |
| 11 | LM_SPLIT | Number(3,0) | SMALLINT NOT NULL |
Split Percentage. The user can split theFee across various Department / Account Codes
Default Value: 100 |