FEE_CLASS_PRICE(SQL Table) |
Index Back |
---|---|
Term Fee Class Pricing table |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
2 | Character(11) | VARCHAR2(11) NOT NULL | Employee ID | |
3 | Character(4) | VARCHAR2(4) NOT NULL | Billing Career | |
4 | Character(4) | VARCHAR2(4) NOT NULL | Term | |
5 | Character(6) | VARCHAR2(6) NOT NULL | Fee Code | |
6 | Character(3) | VARCHAR2(3) NOT NULL |
Session
1=Regular Academic Session 10W=10 Week 12W=Twelve Week 4W1=Four Week - First 4W2=Four Week - Second 4W3=Four Week - Third 4W4=Four Week - Fourth 6W1=Six Week - First 6W2=Six Week - Second 8W1=Eight Week - First 8W2=Eight Week - Second A11=Medical Period 1, 4 Weeks A12=Medical Period 1, 8 Weeks A13=Medical Pd 1, 12 Weeks A21=Medical Period 2, 4 Weeks A22=Medical Period 2, 8 Weeks A23=Medical Period 2, 12 Week FYR=Full Year MIN=Mini Session OEE=Open Entry/Open Exit SM1=Semester 1 SM2=Semester 2 |
|
7 | DateTime(26) | TIMESTAMP NOT NULL | Class Price Date Time | |
8 | Number(5,0) | INTEGER NOT NULL | Class Nbr | |
9 | CLASS_PRICE | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Class Price |
10 | ENRL_ADD_DT | Date(10) | DATE NOT NULL | Enrollment Add Date |
11 | ENRL_DROP_DT | Date(10) | DATE | Enrollment Drop Date |
12 | ADJ_TERM_CD | Character(8) | VARCHAR2(8) NOT NULL | Adjustment Code |
13 | ADJUST_REASON | Character(4) | VARCHAR2(4) NOT NULL | Adjust Reason |
14 | REFUND_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Refund Percentage |
15 | CLASS_SESSION_CODE | Character(3) | VARCHAR2(3) NOT NULL | Session Code |
16 | GL_SATISFIED_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | GL Satisfied Amount |
17 | GL_ASSESSED_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | GL Assessed |
18 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY |