SSF_LT_FEE_RULE (SQL Table)	Index Back
Late Fee Rule Table Child Table to SSF_LATE_FEE_CD

SSF_LT_FEE_RULE

(SQL Table)

Late Fee Rule Table

Child Table to SSF_LATE_FEE_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_CS.SETID
Prompt Table: SP_SETID_NONVW

2 LATE_FEE_CODE Character(6) VARCHAR2(6) NOT NULL Late Fee Code
Default Value: SSF_LATE_FEE_CD.LATE_FEE_CODE

3 SSF_FROM_AMT Number(17,2) DECIMAL(16,2) NOT NULL From Amount

4 SSF_TO_AMT Number(17,2) DECIMAL(16,2) NOT NULL To Amount

5 LATE_FEE_FLAT_AMT Number(11,2) DECIMAL(10,2) NOT NULL Late Fee Flat Amount

6 SSF_LATE_FEE_PCT Number(7,3) DECIMAL(6,3) NOT NULL Late Fee Percentage

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_CS.SETID Prompt Table: SP_SETID_NONVW
2	LATE_FEE_CODE	Character(6)	VARCHAR2(6) NOT NULL	Late Fee Code Default Value: SSF_LATE_FEE_CD.LATE_FEE_CODE
3	SSF_FROM_AMT	Number(17,2)	DECIMAL(16,2) NOT NULL	From Amount
4	SSF_TO_AMT	Number(17,2)	DECIMAL(16,2) NOT NULL	To Amount
5	LATE_FEE_FLAT_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	Late Fee Flat Amount
6	SSF_LATE_FEE_PCT	Number(7,3)	DECIMAL(6,3) NOT NULL	Late Fee Percentage