IT_FIA_ANR_SRCH (SQL View)	Index Back
FIA List Header

IT_FIA_ANR_SRCH

(SQL View)

FIA List Header

SELECT LIST_ID , DESCR , CREATED_BY_USER , LAST_SAVED_BY , LAST_SAVED_DTTM ,LAST_UPDATED_BY , LAST_UPDATE_DTTM FROM %Table(IT_FIA_LST_HDR) WHERE IT_SOURCE = 'NRA'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

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

5 LAST_SAVED_DTTM DateTime(26) TIMESTAMP Last Saved Datetime

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

7 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	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	CREATED_BY_USER	Character(30)	VARCHAR2(30) NOT NULL	Created By
4	LAST_SAVED_BY	Character(30)	VARCHAR2(30) NOT NULL	Last Saved By
5	LAST_SAVED_DTTM	DateTime(26)	TIMESTAMP	Last Saved Datetime
6	LAST_UPDATED_BY	Character(30)	VARCHAR2(30) NOT NULL	LastUpdatedUser
7	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.