BUSINESS_UNITPrompt Table: SP_BU_SF_NONVW
EMPLIDPrompt Table: PEOPLE_SRCH
BILLING_CAREERPrompt Table: ACAD_CAR_TBL
STRMPrompt Table: TERM_VAL_TBL
FEE_CDPrompt Table: TERM_FEE_CD_VW
Default Value: %date
Y/N Table Edit
Default Value: N
TERM_LCK_AMT(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_SF_NONVW |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 3 | BILLING_CAREER |
Character(4) | VARCHAR2(4) NOT NULL |
Billing Career
Prompt Table: ACAD_CAR_TBL |
| 4 | STRM |
Character(4) | VARCHAR2(4) NOT NULL |
Term
Prompt Table: TERM_VAL_TBL |
| 5 | FEE_CD |
Character(6) | VARCHAR2(6) NOT NULL |
Fee Code
Prompt Table: TERM_FEE_CD_VW |
| 6 | OVERRIDE_FEE_AMT | Number(15,2) | DECIMAL(14,2) NOT NULL | Override Fee Amount |
| 7 | SSF_OVERRIDE_DT | Date(10) | DATE |
Override Date
Default Value: %date |
| 8 | OVERRIDE_OPRID | Character(8) | VARCHAR2(8) NOT NULL | Override Oprid |
| 9 | FEE_AMT | Number(15,2) | DECIMAL(14,2) NOT NULL | Fee Amount |
| 10 | LOCK_IN_DT | Date(10) | DATE | Lock In Date |
| 11 | NO_LOCK_IN | Character(1) | VARCHAR2(1) NOT NULL |
No Lock In
Y/N Table Edit Default Value: N |