SCC_SFP_G_LN_VW(SQL View) |
Index Back |
---|---|
Group Line Information/Check |
SELECT A.BUSINESS_UNIT , A.GROUP_ID_SF , GROUP_LINE_NBR ,A.POST_STATUS , ACCOUNT_TYPE_SF , ITEM_TYPE , ITEM_EFFECTIVE_DT , DESCR , EMPLID , DUE_DT , REF1_DESCR , ACAD_CAREER , STDNT_CAR_NBR , STRM , CLASS_NBR , SESSION_CODE , FINANCE_CHARGE , ENCUMBRANCE_DT , ENCUMBERED_AMT , ACAD_YEAR , ITEM_AMT , PAYMENT_PRIORITY , CHARGE_PRIORITY , B.POST_DT , SSF_ERROR_WARN , POST_FLAG , PRIOR_POST_VAL , ACCOUNT_NBR , ACCOUNT_TERM , INSTITUTION , ITEM_NBR , FEE_CD , SEL_GROUP , ADM_APPL_NBR , PAYMENT_ID_NBR , LINE_STATUS , LINE_ACTION , LINE_REASON_CD , PAYMENT_METHOD , CHECK_NUM_SF , THIRD_PARTY , CREDIT_CARD_NBR , CREDIT_CARD_TYPE , CREDIT_CARD_EXP_DT , CREDIT_CARD_ISSUER , CREDIT_CARD_HOLDER , FED_RSRV_BANK_ID , SSF_BNK_ACCT_NUM , BANK_ACCT_TYP , BANK_ACCT_NAME , SF_REVERSAL_IND , TENDER_SPEC , TENDER_CATEGORY , TRACER_NBR , OPRID_QCKPOST , DEPOSIT_NBR , REFUND_NBR , EXT_ORG_ID , REFUND_EMPLID , CONTRACT_NUM , COLLECTION_ID , ITEM_TYPE_CD , OVERRIDE_APPL_NBR , ACAD_PROG , ACAD_PROG2 , ACAD_PROG3 , EXTRA_REFUND_FLAG , ORG_GROUP_ID_SF , ORG_GROUP_LINE_NBR , RECEIPT_NBR , AGING_DT , AGING_FLG , RESTRICT_ACCT_FLG , EXC_ACCT_TYPE_SF , EXC_ACCT_TYPE_FLG , CHARGE_SET_TABLE , EMPLID_SET_TABLE , CONTRACT_EMPLID , WRITEOFF_BY , SRVC_IND_CD , COURSE_LIST , CRSE_ID , BILLING_DT , ACTUAL_BILLING_DT , BILLING_FLAG , WAIVER_CODE , PRIORITY , PRIORITY_PMT_FLG , TRANS_FEE_CD , BILLING_CAREER , LATE_FEE_CODE , CUR_RT_TYPE , RATE_MULT , RATE_DIV , CURRENCY_CD , ORIGNL_CURRENCY_CD , ORIGNL_ITEM_AMT , CREATE_ITEM , ITEM_NBR_SOURCE , TAX_AUTHORITY_CD , GL_FROM_SUBFEE , CLASS_PRICE_DTTM , AID_YEAR , DISBURSEMENT_DATE , ORIG_EFF_DT , SF_DEPOSIT_ID , SF_PMT_REF_NBR , BANK_CD , INVOICE_ID , SSF_RESTRICT_INV , CR_CARD_DIGITS , SSF_INSTMNT_ID FROM PS_GROUP_LINE B , PS_GROUP_CONT_INFO A WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.GROUP_ID_SF = B.GROUP_ID_SF |
# | 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: GROUP_CONT_VW |
2 | GROUP_ID_SF | Character(15) | VARCHAR2(15) NOT NULL | Group ID |
3 | GROUP_LINE_NBR | Number(6,0) | INTEGER NOT NULL |
Group Line Number
Default Value: 999999 |
4 | POST_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Posting Status
B=Balance C=Complete E=Errors I=Incomplete N=Not Posted R=Reversed |
5 | ACCOUNT_TYPE_SF | Character(3) | VARCHAR2(3) NOT NULL |
Account Type
Prompt Table: ACCT_TYP_TBL_SF |
6 | ITEM_TYPE | Character(12) | VARCHAR2(12) NOT NULL |
Item Type
Prompt Table: %EDITTABLE |
7 | ITEM_EFFECTIVE_DT | Date(10) | DATE |
Item Effective Date
Default Value: %DATE |
8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
9 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
10 | DUE_DT | Date(10) | DATE | Due Date |
11 | REF1_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Reference Nbr |
12 | 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 Prompt Table: STDNT_CAREER |
13 | STDNT_CAR_NBR | Number(3,0) | SMALLINT NOT NULL |
Student Career Nbr
Prompt Table: STDNT_CAR_SEQ |
14 | STRM | Character(4) | VARCHAR2(4) NOT NULL |
Term
Prompt Table: SF_TERM_VW |
15 | CLASS_NBR | Number(5,0) | INTEGER NOT NULL |
Class Nbr
Prompt Table: STDNT_ENRL |
16 | 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 Prompt Table: SESSION_TBL |
17 | FINANCE_CHARGE | Character(8) | VARCHAR2(8) NOT NULL | Finance Charge |
18 | ENCUMBRANCE_DT | Date(10) | DATE | Encumbrance Date |
19 | ENCUMBERED_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Amount Encumbered |
20 | ACAD_YEAR | Character(4) | VARCHAR2(4) NOT NULL | Academic Year |
21 | ITEM_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Item Amount |
22 | PAYMENT_PRIORITY | Character(8) | VARCHAR2(8) NOT NULL | Payment Priority |
23 | CHARGE_PRIORITY | Character(8) | VARCHAR2(8) NOT NULL |
Charge Priority List
Prompt Table: PMT_CHRG_TBL |
24 | POST_DT | Date(10) | DATE | The Date a transaction was Posted. |
25 | SSF_ERROR_WARN | Character(1) | VARCHAR2(1) NOT NULL |
Field to hold translate values for Message Types - Error/Warning/Message
E=Error M=Message W=Warning |
26 | POST_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Line Post Flag
D=Deleted N=Not Posted Y=Posted Y/N Table Edit Default Value: N |
27 | PRIOR_POST_VAL | Character(1) | VARCHAR2(1) NOT NULL | Prior Post Value |
28 | ACCOUNT_NBR | Character(10) | VARCHAR2(10) NOT NULL | Account Nbr |
29 | ACCOUNT_TERM | Character(4) | VARCHAR2(4) NOT NULL | Account Term |
30 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
31 | ITEM_NBR | Character(15) | VARCHAR2(15) NOT NULL | Item Nbr |
32 | FEE_CD | Character(6) | VARCHAR2(6) NOT NULL | Fee Code |
33 | SEL_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Tuition Group |
34 | ADM_APPL_NBR | Character(8) | VARCHAR2(8) NOT NULL |
Application Nbr
Prompt Table: ADM_APPL_DT_VW |
35 | PAYMENT_ID_NBR | Number(12,0) | DECIMAL(12) NOT NULL |
Payment ID Nbr
Prompt Table: %EDITTABLE2 |
36 | LINE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Line Status
A=Active C=Contingent D=Disputed H=Hold R=Reversed Default Value: A |
37 | 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 Default Value: GRP |
38 | LINE_REASON_CD | Character(4) | VARCHAR2(4) NOT NULL | Line Reason Code |
39 | PAYMENT_METHOD | Character(3) | VARCHAR2(3) NOT NULL |
Payment Method
CC=Credit Card CHK=Check CSH=Cash DB=Debit Card EC=Electronic Check EFT=Electronic Funds Transfer LBX=Lockbox TPC=Third Party Check WIR=Wire Transfer |
40 | CHECK_NUM_SF | Character(30) | VARCHAR2(30) NOT NULL | Check Nbr |
41 | THIRD_PARTY | Character(30) | VARCHAR2(30) NOT NULL | Third Party Check Name |
42 | CREDIT_CARD_NBR | Character(44) | VARCHAR2(44) NOT NULL | Card Number |
43 | CREDIT_CARD_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Credit Card Type
AE=American Express DC=Diners' Club DI=Diners Club MC=MasterCard VI=VISA Prompt Table: CREDIT_CARD_TYP |
44 | CREDIT_CARD_EXP_DT | Date(10) | DATE | Expiration Date |
45 | CREDIT_CARD_ISSUER | Character(20) | VARCHAR2(20) NOT NULL | Credit Card Issuer |
46 | CREDIT_CARD_HOLDER | Character(30) | VARCHAR2(30) NOT NULL | Credit Card Holder |
47 | FED_RSRV_BANK_ID | Character(10) | VARCHAR2(10) NOT NULL | Federal Reserve Bank ID |
48 | SSF_BNK_ACCT_NUM | Character(44) | VARCHAR2(44) NOT NULL | Bank Account Number |
49 | BANK_ACCT_TYP | Character(1) | VARCHAR2(1) NOT NULL |
Bank Account Type
C=Checking S=Savings |
50 | BANK_ACCT_NAME | Character(30) | VARCHAR2(30) NOT NULL | Bank Account Holder Name |
51 | SF_REVERSAL_IND | Character(1) | VARCHAR2(1) NOT NULL |
Reversal Indicator
Y/N Table Edit Default Value: N |
52 | TENDER_SPEC | Character(1) | VARCHAR2(1) NOT NULL | Tender Specific |
53 | TENDER_CATEGORY | Character(3) | VARCHAR2(3) NOT NULL |
Tender Category
CC=Credit Card CCI=Credit Card In CCO=Credit Card Out CK=Check CKI=Check In CKO=Check Out CS=Cash CSI=Cash In CSO=Cash Out DB=Debit Card DBI=Debit Card In DBO=Debit Card Out DD=Direct Deposit DDI=Direct Debit DDO=Direct Deposit EC=Electronic Check TP=Third Party Check TPI=Third Party Check In WIR=Wire Transfer |
54 | TRACER_NBR | Character(30) | VARCHAR2(30) NOT NULL | Tracer Number |
55 | OPRID_QCKPOST | Character(30) | VARCHAR2(30) NOT NULL | Quick Post Oprid |
56 | DEPOSIT_NBR | Number(12,0) | DECIMAL(12) NOT NULL | Deposit Nbr |
57 | REFUND_NBR | Number(12,0) | DECIMAL(12) NOT NULL | Refund Nbr |
58 | EXT_ORG_ID | Character(11) | VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table: EXT_ORG_TBL |
59 | REFUND_EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Refund ID |
60 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL |
Contract Number
Prompt Table: TP_CONTRACT_VW |
61 | COLLECTION_ID | Number(12,0) | DECIMAL(12) NOT NULL | Collection ID |
62 | ITEM_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Item Type Code
A=Application Fee B=Billing Only C=Charge D=Deposit F=Financial Aid G=GL Interface Only H=Withholding I=Interest L=Pre-Paid Tuition P=Payment R=Refund T=Transfers V=Contributor Relations W=Waiver X=Write-off Z=Pay Plan Credit |
63 | OVERRIDE_APPL_NBR | Character(1) | VARCHAR2(1) NOT NULL |
Override Application Number
Y/N Table Edit Default Value: N |
64 | ACAD_PROG | Character(5) | VARCHAR2(5) NOT NULL | Academic Program |
65 | ACAD_PROG2 | Character(5) | VARCHAR2(5) NOT NULL | Academic Program |
66 | ACAD_PROG3 | Character(5) | VARCHAR2(5) NOT NULL | Academic Program 3 |
67 | EXTRA_REFUND_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Extra Refund Flag |
68 | ORG_GROUP_ID_SF | Character(15) | VARCHAR2(15) NOT NULL | Original Group ID |
69 | ORG_GROUP_LINE_NBR | Number(6,0) | INTEGER NOT NULL | Original Group Line Nbr |
70 | RECEIPT_NBR | Number(12,0) | DECIMAL(12) NOT NULL | Receipt Number |
71 | AGING_DT | Date(10) | DATE | Aging Date |
72 | AGING_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Aging Flag
Y/N Table Edit Default Value: N |
73 | RESTRICT_ACCT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Pay Entered Acct Only
Y/N Table Edit Default Value: N |
74 | EXC_ACCT_TYPE_SF | Character(3) | VARCHAR2(3) NOT NULL |
Excess Account Type SF
Prompt Table: ACCT_TYP_SF_VW |
75 | EXC_ACCT_TYPE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Excess Account Type Flag
Y/N Table Edit Default Value: N |
76 | CHARGE_SET_TABLE | Character(1) | VARCHAR2(1) NOT NULL |
Charge Set Table Flag
Default Value: N |
77 | EMPLID_SET_TABLE | Character(1) | VARCHAR2(1) NOT NULL |
Emplid Set Table
Default Value: N |
78 | CONTRACT_EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Contract ID
Prompt Table: PEOPLE_SRCH_SF |
79 | WRITEOFF_BY | Character(2) | VARCHAR2(2) NOT NULL |
Writeoff By
01=Entire Balance 02=Account Number 03=By Item Type 04=Account Type |
80 | SRVC_IND_CD | Character(3) | VARCHAR2(3) NOT NULL |
Service Indicator Cd
Prompt Table: %EDITTABLE4 |
81 | COURSE_LIST | Character(9) | VARCHAR2(9) NOT NULL | Course List |
82 | CRSE_ID | Character(6) | VARCHAR2(6) NOT NULL | Course ID |
83 | BILLING_DT | Date(10) | DATE | Billing Date |
84 | ACTUAL_BILLING_DT | Date(10) | DATE | Actual Billing Date |
85 | BILLING_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Billing Flag
Y/N Table Edit Default Value: N |
86 | WAIVER_CODE | Character(6) | VARCHAR2(6) NOT NULL | Waiver Code |
87 | PRIORITY | Number(3,0) | SMALLINT NOT NULL | Priority |
88 | PRIORITY_PMT_FLG | Character(1) | VARCHAR2(1) NOT NULL | Payment Priority Flag |
89 | TRANS_FEE_CD | Character(8) | VARCHAR2(8) NOT NULL | Transaction Fee Code |
90 | BILLING_CAREER | Character(4) | VARCHAR2(4) NOT NULL | Billing Career |
91 | LATE_FEE_CODE | Character(6) | VARCHAR2(6) NOT NULL | Late Fee Code |
92 | CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Currency Rate Type |
93 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
94 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
95 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
96 | ORIGNL_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
97 | ORIGNL_ITEM_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Item Amount |
98 | CREATE_ITEM | Character(1) | VARCHAR2(1) NOT NULL |
Create Item
Y/N Table Edit Default Value: N |
99 | ITEM_NBR_SOURCE | Character(15) | VARCHAR2(15) NOT NULL | Item Nbr - Src Charge Nbr |
100 | TAX_AUTHORITY_CD | Character(3) | VARCHAR2(3) NOT NULL | Tax Authority |
101 | GL_FROM_SUBFEE | Character(1) | VARCHAR2(1) NOT NULL | GL from Sub Fees |
102 | CLASS_PRICE_DTTM | DateTime(26) | TIMESTAMP | Class Price Date Time |
103 | AID_YEAR | Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Prompt Table: AID_YEAR_TBL |
104 | DISBURSEMENT_DATE | Date(10) | DATE | Disbursement Date |
105 | ORIG_EFF_DT | Date(10) | DATE | Original Effective Date |
106 | SF_DEPOSIT_ID | Character(10) | VARCHAR2(10) NOT NULL | Deposit ID |
107 | SF_PMT_REF_NBR | Character(12) | VARCHAR2(12) NOT NULL | Reference Nbr |
108 | BANK_CD | Character(11) | VARCHAR2(11) NOT NULL | Bank ID |
109 | INVOICE_ID | Character(22) | VARCHAR2(22) NOT NULL |
Invoice Number
Prompt Table: %EDITTABLE3 |
110 | SSF_RESTRICT_INV | Character(1) | VARCHAR2(1) NOT NULL |
This field indicates that the payment will be held until an invoice is provided.
Y/N Table Edit Default Value: N |
111 | CR_CARD_DIGITS | Character(4) | VARCHAR2(4) NOT NULL | Card Number's Last Four Digits |
112 | SSF_INSTMNT_ID | Number(3,0) | SMALLINT NOT NULL | Installment ID |