BUSINESS_UNITDefault Value: OPR_DEF_TBL_CS.BUSINESS_UNIT
Prompt Table: SP_BU_SF_NONVW
EMPLIDPrompt Table: PEOPLE_SRCH
BILLING_CAREERPrompt Table: ACAD_CAR_TBL
STRMPrompt Table: TERM_VAL_TBL
Default Value: %date
TERM_LCK_CD(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
Default Value: OPR_DEF_TBL_CS.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 | AGG_TERM_FLG | Character(1) | VARCHAR2(1) NOT NULL | Aggregate Term Flag |
| 6 | OVERRIDE_AGG_AMT | Number(15,2) | DECIMAL(14,2) NOT NULL | Override Aggregate 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 | AGG_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Aggregate Amount |
| 10 | LOCK_IN_DT | Date(10) | DATE | Lock In Date |
| 11 | SEL_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Tuition Group |