LED_INQ_ADJPER (SQL Table)	Index Back
Inquiry Criteria - Adj Periods

LED_INQ_ADJPER

(SQL Table)

Inquiry Criteria - Adj Periods

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Default Value: LED_INQ_CRIT.OPRID

2 SAVED_SEARCH Character(30) VARCHAR2(30) NOT NULL Saved Search Name
Default Value: LED_INQ_CRIT.SAVED_SEARCH

3 INQUIRY_TYPE Character(1) VARCHAR2(1) NOT NULL Inquiry Type specifies Saved Search or Personalization to distinguish the type of search crieria.
P=Personalization
S=Saved Search
Default Value: P

4 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.

5 SELECT_FLAG Character(1) VARCHAR2(1) NOT NULL Selection Flag
N=No
Y=Yes
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Default Value: LED_INQ_CRIT.OPRID
2	SAVED_SEARCH	Character(30)	VARCHAR2(30) NOT NULL	Saved Search Name Default Value: LED_INQ_CRIT.SAVED_SEARCH
3	INQUIRY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Inquiry Type specifies Saved Search or Personalization to distinguish the type of search crieria. P=Personalization S=Saved Search Default Value: P
4	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
5	SELECT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Selection Flag N=No Y=Yes Y/N Table Edit Default Value: N