eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.IGF_SE_AUTHORIZATION_V

Object Details

Object Name:	IGF_SE_AUTHORIZATION_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGF.IGF_SE_AUTHORIZATION_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Public view to derive active work authorizations

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
AUTHORIZATION_ID	NUMBER	(15)	Yes	Unique identifier for identifying an authorization
PERSON_ID	NUMBER	(15)	Yes	Unique Person Identifier mapping to HZ_PARTIES.PARTY_ID
AUTHORIZED_AMT	NUMBER		Yes	Authorized Amount
AUTHORIZATION_DATE	DATE			Date of Authorization
PERSON_FIRST_NAME_TXT	VARCHAR2	(150)	Yes	Person First Name
PERSON_LAST_NAME_TXT	VARCHAR2	(150)	Yes	Person Last Name
BIRTH_DATE	DATE		Yes	Person's Date of Birth
SOCIAL_SECURITY_NUMBER	VARCHAR2	(20)	Yes	Person's Social Security Number recorded while creating the authorization
FUND_ID	NUMBER	(15)	Yes	Unique identifier of a Fund against which authorization was initiated
FUND_CODE_TXT	VARCHAR2	(30)	Yes	User configurable code to identify a Fund
SYS_FUND_SOURCE_CODE	VARCHAR2	(30)	Yes	Valid values are ENDOWMENT, FEDERAL, INSTITUTIONAL, OUTSIDE, STATE
SYS_FUND_SOURCE_NAME	VARCHAR2	(80)	Yes	Translatable meanings for the lookup codes of lookup_type 'IGF_AW_FUND_SOURCE'
FUND_TYPE_TXT	VARCHAR2	(30)	Yes	User configurable type of a Fund
SYS_FUND_TYPE_CODE	VARCHAR2	(30)	Yes	Valid values are the lookup codes for the lookup type 'IGF_AW_SYS_FUND_TYPE'
SYS_FUND_TYPE_NAME	VARCHAR2	(80)	Yes	Translatable meaning for the system fund type codes.
AW_CAL_TYPE_TXT	VARCHAR2	(10)	Yes	Award Year Calendar Type for the system award year type of 'AWARD'
AW_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Unique number to identify the award calendar instance
AUTHORIZATION_START_DATE	DATE			Effective start date of Authorization
AUTHORIZATION_END_DATE	DATE			Effective end date of Authorization.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT AUTHORIZATION_ID
,      PERSON_ID
,      AUTHORIZED_AMT
,      AUTHORIZATION_DATE
,      PERSON_FIRST_NAME_TXT
,      PERSON_LAST_NAME_TXT
,      BIRTH_DATE
,      SOCIAL_SECURITY_NUMBER
,      FUND_ID
,      FUND_CODE_TXT
,      SYS_FUND_SOURCE_CODE
,      SYS_FUND_SOURCE_NAME
,      FUND_TYPE_TXT
,      SYS_FUND_TYPE_CODE
,      SYS_FUND_TYPE_NAME
,      AW_CAL_TYPE_TXT
,      AW_SEQUENCE_NUMBER
,      AUTHORIZATION_START_DATE
,      AUTHORIZATION_END_DATE
FROM APPS.IGF_SE_AUTHORIZATION_V;

Dependencies

[top of page]

APPS.IGF_SE_AUTHORIZATION_V references the following:

APPS: IGF_AW_FUND_CAT; IGF_AW_FUND_MAST_ALL; IGF_LOOKUPS_VIEW; IGF_SE_AUTH; IGF_SL_LAR_CREATION - show dependent code

APPS.IGF_SE_AUTHORIZATION_V is not referenced by any database object