ITEM_SF (SQL Table)	Index Back
Item Record

ITEM_SF

(SQL Table)

Item Record

Parent Record Of BI_BILL_DTL_VW ITEM_LINE_SF SSF_ITEM_INV

# 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 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value

3 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
O=Organization
P=Person

4 ITEM_NBR Character(15) VARCHAR2(15) NOT NULL Item Nbr

5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PEOPLE_SRCH

6 ACCOUNT_NBR Character(10) VARCHAR2(10) NOT NULL Account Nbr
Prompt Table: ACCOUNT_SF_O

7 ACCOUNT_TERM Character(4) VARCHAR2(4) NOT NULL Account Term
Prompt Table: TERM_VAL_TBL

8 ACAD_YEAR Character(4) VARCHAR2(4) NOT NULL Academic Year

9 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type
Prompt Table: ITEM_TYPE_TBL

10 ITEM_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Item Amount

11 APPLIED_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Applied Amount

12 ENCUMBERED_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Amount Encumbered

13 REF1_DESCR Character(30) VARCHAR2(30) NOT NULL Reference Nbr

14 ITEM_BALANCE Signed Number(18,2) DECIMAL(16,2) NOT NULL Item Balance

15 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

16 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr

17 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

18 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr

19 FEE_CD Character(6) VARCHAR2(6) NOT NULL Fee Code

20 SEL_GROUP Character(10) VARCHAR2(10) NOT NULL Tuition Group

21 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr

22 GL_SATISFIED_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL GL Satisfied Amount

23 GL_ASSESSED_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL GL Assessed

24 PAYMENT_ID_NBR Number(12,0) DECIMAL(12) NOT NULL Payment ID Nbr

25 ITEM_TERM Character(4) VARCHAR2(4) NOT NULL Item Term
Prompt Table: TERM_VAL_TBL

26 ORIGINAL_ACCT_TERM Character(4) VARCHAR2(4) NOT NULL Original Account Term

27 BILLING_CAREER Character(4) VARCHAR2(4) NOT NULL Billing Career

28 DEPOSIT_NBR Number(12,0) DECIMAL(12) NOT NULL Deposit Nbr

29 REFUND_NBR Number(12,0) DECIMAL(12) NOT NULL Refund Nbr

30 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

31 REFUND_EMPLID Character(11) VARCHAR2(11) NOT NULL Refund ID
Prompt Table: PEOPLE_SRCH

32 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number

33 COLLECTION_ID Number(12,0) DECIMAL(12) NOT NULL Collection ID

34 RECEIPT_NBR Number(12,0) DECIMAL(12) NOT NULL Receipt Number

35 ACCOUNT_TYPE_SF Character(3) VARCHAR2(3) NOT NULL Account Type

36 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

37 CONTRACT_EMPLID Character(11) VARCHAR2(11) NOT NULL Contract ID

38 CHARGE_PRIORITY Character(8) VARCHAR2(8) NOT NULL Charge Priority List

39 COURSE_LIST Character(9) VARCHAR2(9) NOT NULL Course List

40 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID

41 WAIVER_CODE Character(6) VARCHAR2(6) NOT NULL Waiver Code

42 PRIORITY Number(3,0) SMALLINT NOT NULL Priority

43 PRIORITY_PMT_FLG Character(1) VARCHAR2(1) NOT NULL Payment Priority Flag

44 NRA_TAXATION_SWTCH Character(1) VARCHAR2(1) NOT NULL NRA Taxation Option
C=NRA Tax W/Current Info
N=No NRA Taxes
Y/N Table Edit
Default Value: N

45 GL_BALANCED_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL GL Assessed

46 STATE_TAX_RT Number(7,6) DECIMAL(6,6) NOT NULL State Tax Rate

47 LOCAL_TAX_RT Number(7,6) DECIMAL(6,6) NOT NULL Local Tax Rate

48 FEDERAL_TAX_RT Signed Number(8,6) DECIMAL(6,6) NOT NULL Federal Tax Rate

49 BILLING_DT Date(10) DATE Billing Date

50 DUE_DT Date(10) DATE Due Date

51 ACTUAL_BILLING_DT Date(10) DATE Actual Billing Date

52 CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL Calendar Year

53 SRVC_IND_DTTM DateTime(26) TIMESTAMP Service Indicator Date-Time field

54 TAX_ADJ_WHOLDINGS Signed Number(12,2) DECIMAL(10,2) NOT NULL Gross Taxable Payments YTD

55 TRANS_FEE_CD Character(8) VARCHAR2(8) NOT NULL Transaction Fee Code

56 LATE_FEE_CODE Character(6) VARCHAR2(6) NOT NULL Late Fee Code

57 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type

58 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

59 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

60 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

61 ORIGNL_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

62 ORIGNL_ITEM_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Item Amount

63 ITEM_STATUS Character(1) VARCHAR2(1) NOT NULL Item Status
A=Active
C=Completed
I=Initiated
N=Notified
O=Ordered
P=Paid Off
R=Received
S=Second Notification
T=Returned
W=Waived
X=Cancelled
Default Value: A

64 TRANSFER_DT Date(10) DATE Transfer Date

65 TRANSFER_STATUS Character(1) VARCHAR2(1) NOT NULL Transfer Status
C=Complete Transfer
N=No Transfer
P=Partial Transfer
Default Value: N

66 TRANSFER_PAYMNT_ID Character(15) VARCHAR2(15) NOT NULL Transfer Payment ID

67 TRANSFER_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Transfer Amt

68 ITEM_NBR_SOURCE Character(15) VARCHAR2(15) NOT NULL Item Nbr - Src Charge Nbr

69 TAX_AUTHORITY_CD Character(3) VARCHAR2(3) NOT NULL Tax Authority

70 CONTRACT_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Contract Amt

71 INTEREST_DT Date(10) DATE Interest Date

72 T4_SENT_AMT Signed Number(12,2) DECIMAL(10,2) NOT NULL T4 Sent Amt

73 GL_FROM_SUBFEE Character(1) VARCHAR2(1) NOT NULL GL from Sub Fees

74 ITEM_EFFECTIVE_DT Date(10) DATE Item Effective Date
Default Value: %DATE

75 TRACER_NBR Character(30) VARCHAR2(30) NOT NULL Tracer Number

76 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
Prompt Table: AID_YEAR_TBL

77 DISBURSEMENT_DATE Date(10) DATE Disbursement Date

78 ORIG_EFF_DT Date(10) DATE Original Effective Date

79 SF_DEPOSIT_ID Character(10) VARCHAR2(10) NOT NULL Deposit ID

80 LAST_ACTIVITY_DATE Date(10) DATE Last Activity Date

81 REFUND_EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL Refund External Org ID
Prompt Table: EXT_ORG_TBL

82 REFUND_ORG_CONTACT Number(4,0) SMALLINT NOT NULL Refund Org Contact
Prompt Table: ORG_CONT_REF_VW

83 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code

84 SF_PMT_REF_NBR Character(12) VARCHAR2(12) NOT NULL Reference Nbr

85 SF_ADM_APPL_DEL Character(1) VARCHAR2(1) NOT NULL Application Deleted
Y/N Table Edit
Default Value: N

86 CLASS_CRSE_FEE_IND Character(1) VARCHAR2(1) NOT NULL Class/Course Fee Indicator
C=Class Fee
L=Course List Fee
O=Course Fee

87 SSF_BILLED_AMOUNT Signed Number(18,2) DECIMAL(16,2) NOT NULL Total Billed Amount

88 SSF_INSTMNT_ID Number(3,0) SMALLINT NOT NULL Installment ID

89 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By

90 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created

91 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By

92 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time

#	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	COMMON_ID	Character(11)	VARCHAR2(11) NOT NULL	Common ID to store Personal ID / Ext Org ID value
3	SA_ID_TYPE	Character(1)	VARCHAR2(1) NOT NULL	ID Type O=Organization P=Person
4	ITEM_NBR	Character(15)	VARCHAR2(15) NOT NULL	Item Nbr
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
6	ACCOUNT_NBR	Character(10)	VARCHAR2(10) NOT NULL	Account Nbr Prompt Table: ACCOUNT_SF_O
7	ACCOUNT_TERM	Character(4)	VARCHAR2(4) NOT NULL	Account Term Prompt Table: TERM_VAL_TBL
8	ACAD_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Academic Year
9	ITEM_TYPE	Character(12)	VARCHAR2(12) NOT NULL	Item Type Prompt Table: ITEM_TYPE_TBL
10	ITEM_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Item Amount
11	APPLIED_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Applied Amount
12	ENCUMBERED_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Amount Encumbered
13	REF1_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Reference Nbr
14	ITEM_BALANCE	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Item Balance
15	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
16	STDNT_CAR_NBR	Number(3,0)	SMALLINT NOT NULL	Student Career Nbr
17	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
18	CLASS_NBR	Number(5,0)	INTEGER NOT NULL	Class Nbr
19	FEE_CD	Character(6)	VARCHAR2(6) NOT NULL	Fee Code
20	SEL_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Tuition Group
21	ADM_APPL_NBR	Character(8)	VARCHAR2(8) NOT NULL	Application Nbr
22	GL_SATISFIED_AMT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	GL Satisfied Amount
23	GL_ASSESSED_AMT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	GL Assessed
24	PAYMENT_ID_NBR	Number(12,0)	DECIMAL(12) NOT NULL	Payment ID Nbr
25	ITEM_TERM	Character(4)	VARCHAR2(4) NOT NULL	Item Term Prompt Table: TERM_VAL_TBL
26	ORIGINAL_ACCT_TERM	Character(4)	VARCHAR2(4) NOT NULL	Original Account Term
27	BILLING_CAREER	Character(4)	VARCHAR2(4) NOT NULL	Billing Career
28	DEPOSIT_NBR	Number(12,0)	DECIMAL(12) NOT NULL	Deposit Nbr
29	REFUND_NBR	Number(12,0)	DECIMAL(12) NOT NULL	Refund Nbr
30	EXT_ORG_ID	Character(11)	VARCHAR2(11) NOT NULL	External Org ID
31	REFUND_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Refund ID Prompt Table: PEOPLE_SRCH
32	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Number
33	COLLECTION_ID	Number(12,0)	DECIMAL(12) NOT NULL	Collection ID
34	RECEIPT_NBR	Number(12,0)	DECIMAL(12) NOT NULL	Receipt Number
35	ACCOUNT_TYPE_SF	Character(3)	VARCHAR2(3) NOT NULL	Account Type
36	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
37	CONTRACT_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Contract ID
38	CHARGE_PRIORITY	Character(8)	VARCHAR2(8) NOT NULL	Charge Priority List
39	COURSE_LIST	Character(9)	VARCHAR2(9) NOT NULL	Course List
40	CRSE_ID	Character(6)	VARCHAR2(6) NOT NULL	Course ID
41	WAIVER_CODE	Character(6)	VARCHAR2(6) NOT NULL	Waiver Code
42	PRIORITY	Number(3,0)	SMALLINT NOT NULL	Priority
43	PRIORITY_PMT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Payment Priority Flag
44	NRA_TAXATION_SWTCH	Character(1)	VARCHAR2(1) NOT NULL	NRA Taxation Option C=NRA Tax W/Current Info N=No NRA Taxes Y/N Table Edit Default Value: N
45	GL_BALANCED_AMT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	GL Assessed
46	STATE_TAX_RT	Number(7,6)	DECIMAL(6,6) NOT NULL	State Tax Rate
47	LOCAL_TAX_RT	Number(7,6)	DECIMAL(6,6) NOT NULL	Local Tax Rate
48	FEDERAL_TAX_RT	Signed Number(8,6)	DECIMAL(6,6) NOT NULL	Federal Tax Rate
49	BILLING_DT	Date(10)	DATE	Billing Date
50	DUE_DT	Date(10)	DATE	Due Date
51	ACTUAL_BILLING_DT	Date(10)	DATE	Actual Billing Date
52	CALENDAR_YEAR	Number(4,0)	SMALLINT NOT NULL	Calendar Year
53	SRVC_IND_DTTM	DateTime(26)	TIMESTAMP	Service Indicator Date-Time field
54	TAX_ADJ_WHOLDINGS	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Gross Taxable Payments YTD
55	TRANS_FEE_CD	Character(8)	VARCHAR2(8) NOT NULL	Transaction Fee Code
56	LATE_FEE_CODE	Character(6)	VARCHAR2(6) NOT NULL	Late Fee Code
57	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
58	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
59	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
60	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
61	ORIGNL_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
62	ORIGNL_ITEM_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Item Amount
63	ITEM_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Item Status A=Active C=Completed I=Initiated N=Notified O=Ordered P=Paid Off R=Received S=Second Notification T=Returned W=Waived X=Cancelled Default Value: A
64	TRANSFER_DT	Date(10)	DATE	Transfer Date
65	TRANSFER_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Transfer Status C=Complete Transfer N=No Transfer P=Partial Transfer Default Value: N
66	TRANSFER_PAYMNT_ID	Character(15)	VARCHAR2(15) NOT NULL	Transfer Payment ID
67	TRANSFER_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Transfer Amt
68	ITEM_NBR_SOURCE	Character(15)	VARCHAR2(15) NOT NULL	Item Nbr - Src Charge Nbr
69	TAX_AUTHORITY_CD	Character(3)	VARCHAR2(3) NOT NULL	Tax Authority
70	CONTRACT_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Contract Amt
71	INTEREST_DT	Date(10)	DATE	Interest Date
72	T4_SENT_AMT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	T4 Sent Amt
73	GL_FROM_SUBFEE	Character(1)	VARCHAR2(1) NOT NULL	GL from Sub Fees
74	ITEM_EFFECTIVE_DT	Date(10)	DATE	Item Effective Date Default Value: %DATE
75	TRACER_NBR	Character(30)	VARCHAR2(30) NOT NULL	Tracer Number
76	AID_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Aid Year Prompt Table: AID_YEAR_TBL
77	DISBURSEMENT_DATE	Date(10)	DATE	Disbursement Date
78	ORIG_EFF_DT	Date(10)	DATE	Original Effective Date
79	SF_DEPOSIT_ID	Character(10)	VARCHAR2(10) NOT NULL	Deposit ID
80	LAST_ACTIVITY_DATE	Date(10)	DATE	Last Activity Date
81	REFUND_EXT_ORG_ID	Character(11)	VARCHAR2(11) NOT NULL	Refund External Org ID Prompt Table: EXT_ORG_TBL
82	REFUND_ORG_CONTACT	Number(4,0)	SMALLINT NOT NULL	Refund Org Contact Prompt Table: ORG_CONT_REF_VW
83	TAX_CD	Character(8)	VARCHAR2(8) NOT NULL	Tax Code
84	SF_PMT_REF_NBR	Character(12)	VARCHAR2(12) NOT NULL	Reference Nbr
85	SF_ADM_APPL_DEL	Character(1)	VARCHAR2(1) NOT NULL	Application Deleted Y/N Table Edit Default Value: N
86	CLASS_CRSE_FEE_IND	Character(1)	VARCHAR2(1) NOT NULL	Class/Course Fee Indicator C=Class Fee L=Course List Fee O=Course Fee
87	SSF_BILLED_AMOUNT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Total Billed Amount
88	SSF_INSTMNT_ID	Number(3,0)	SMALLINT NOT NULL	Installment ID
89	SCC_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Created By
90	SCC_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Created
91	SCC_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Updated By
92	SCC_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Last Update Date/Time