IT_FIA_ARCH_HDR (SQL Table)	Index Back
FIA List Archive Header

IT_FIA_ARCH_HDR

(SQL Table)

FIA List Archive Header

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LIST_ID Character(11) VARCHAR2(11) NOT NULL Financial Impact List ID

2 IT_SOURCE Character(3) VARCHAR2(3) NOT NULL ITAM Source for Financial Impact
ME=Manage Exceptions
NRA=Assets Not Reporting

3 LAST_SAVED_DTTM DateTime(26) TIMESTAMP Last Saved Datetime

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

5 CREATED_BY_USER Character(30) VARCHAR2(30) NOT NULL Created By

6 LAST_SAVED_BY Character(30) VARCHAR2(30) NOT NULL Last Saved By

7 LAST_UPDATED_BY Character(30) VARCHAR2(30) NOT NULL LastUpdatedUser

8 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LIST_ID	Character(11)	VARCHAR2(11) NOT NULL	Financial Impact List ID
2	IT_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	ITAM Source for Financial Impact ME=Manage Exceptions NRA=Assets Not Reporting
3	LAST_SAVED_DTTM	DateTime(26)	TIMESTAMP	Last Saved Datetime
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	CREATED_BY_USER	Character(30)	VARCHAR2(30) NOT NULL	Created By
6	LAST_SAVED_BY	Character(30)	VARCHAR2(30) NOT NULL	Last Saved By
7	LAST_UPDATED_BY	Character(30)	VARCHAR2(30) NOT NULL	LastUpdatedUser
8	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	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.