ITEM_LINE_CHGDT

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 DTTM_STAMP DateTime(26) TIMESTAMP NOT NULL Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

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

4 LINE_SEQ_NBR Number(3,0) SMALLINT NOT NULL Line Sequence Nbr

5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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

7 LINE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Line Amount

8 DUE_DT Date(10) DATE Due Date

9 NEW_DUE_DT Date(10) DATE New Due Date

10 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

11 DATE_CHANGE_FLAG Character(1) VARCHAR2(1) NOT NULL Date Change Flag
Y/N Table Edit
Default Value: N

12 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

13 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	DTTM_STAMP	DateTime(26)	TIMESTAMP NOT NULL	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
3	ITEM_NBR	Character(15)	VARCHAR2(15) NOT NULL	Item Nbr
4	LINE_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Line Sequence Nbr
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
6	EXT_ORG_ID	Character(11)	VARCHAR2(11) NOT NULL	External Org ID
7	LINE_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Line Amount
8	DUE_DT	Date(10)	DATE	Due Date
9	NEW_DUE_DT	Date(10)	DATE	New Due Date
10	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
11	DATE_CHANGE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Date Change Flag Y/N Table Edit Default Value: N
12	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
13	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.