SSF_SAH_FEE_PST(SQL Table) |
Index Back |
|---|---|
Run Cntl - SA-HELP Deferral |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT |
| 5 | COMMON_ID | Character(11) | VARCHAR2(11) NOT NULL | Common ID to store Personal ID / Ext Org ID value |
| 6 | SA_ID_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
ID Type
O=Organization P=Person |
| 7 | STRM | Character(4) | VARCHAR2(4) NOT NULL | Term |
| 8 | LINE_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Line Sequence Nbr |
| 9 | ACCOUNT_TYPE_SF | Character(3) | VARCHAR2(3) NOT NULL | Account Type |
| 10 | ITEM_NBR | Character(15) | VARCHAR2(15) NOT NULL | Item Nbr |
| 11 | ITEM_TYPE | Character(12) | VARCHAR2(12) NOT NULL | Item Type |
| 12 | ITEM_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Item Amount |
| 13 | LINE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Line Status
A=Active C=Contingent D=Disputed H=Hold R=Reversed |
| 14 | LINE_ACTION | Character(3) | VARCHAR2(3) NOT NULL |
Line Action
APP=Application Generated BCK=Backing Out Term Fees CCP=Credit Card Payment CRV=Charge Reversal CSH=Cashiering GRP=Group Posting INT=Multi Year Interest Calc LAT=Late Fee Processing NRA=Tax Calculations PAY=Payment Posted PMT=Excess Payment QBK=Quick Post Back Up QCK=Posting Page REF=Refund Processing SSP=Self service payment SYS=System Generated TAX=Tax Adjustment Page TPA=Third Party - Online TUI=Tuition Calculation WRO=Writeoff Processing |
| 15 | SF_REVERSAL_IND | Character(1) | VARCHAR2(1) NOT NULL | Reversal Indicator |
| 16 | CREATE_ITEM | Character(1) | VARCHAR2(1) NOT NULL | Create Item |
| 17 | REF1_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Reference Nbr |
| 18 | ITEM_EFFECTIVE_DT | Date(10) | DATE | Item Effective Date |
| 19 | DUE_DT | Date(10) | DATE | Expected Birth Date |
| 20 | PAYMENT_ID_NBR | Number(12,0) | DECIMAL(12) NOT NULL | Payment ID Nbr |
| 21 | SESSION_CODE | 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 |
| 22 | STDNT_CAR_NBR | Number(3,0) | SMALLINT NOT NULL | Student Career Nbr |
| 23 | ACAD_CAREER | Character(4) | VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD) BBL=Vocational Coaching (NLD) BOL=Vocational Training (NLD) BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EDU=Education (NLD) EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School NONA=Non Award PGRD=Postgraduate RSCH=Research TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VAVO=Advanced General Educ. (NLD) VETM=Veterinary Medicine |
| 24 | ACAD_PROG | Character(5) | VARCHAR2(5) NOT NULL | Academic Program |
| 25 | SSF_HECS_CHARGE | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | HECS Charge |
| 26 | SSF_HECS_PAYMENT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | HECS Payment |
| 27 | SSF_HECS_DEFERRAL | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | HECS Deferral |
| 28 | SSF_SAH_OVR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Override Flag
N=Override Flag No Y=Override Flag Yes |
| 29 | SSR_HECS_XMPT_STAT | Character(3) | VARCHAR2(3) NOT NULL | HECS Exempt Status |