[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FV_FACTS_SUBMISSION |
|---|---|
| Object Type: | TABLE |
| Owner: | FV |
| FND Design Data: |  FV.FV_FACTS_SUBMISSION
|
| Subobject Name: | |
| Status: | VALID |
FV_FACTS_SUBMISSION stores FACTS II submission information and is the base table for the FACTS II Submission form. It is also the base table for the detail region of the Appropriation Parameter form.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TREASURY_SYMBOL_ID | NUMBER | (15) | Treasury symbol identifier | |
| RUN_MODE | VARCHAR2 | (1) | Run mode in which FACTS process is submitted | |
| SET_OF_BOOKS_ID | NUMBER | (15) | Set of Books identifier | |
| PREPARER_ID | VARCHAR2 | (8) | Preparer identifier | |
| CERTIFIED_ID | VARCHAR2 | (8) | Certified identifier | |
| REP_FYR | VARCHAR2 | (4) | Report fiscal year | |
| REP_QTR | VARCHAR2 | (1) | Report quarter | |
| FIRST_NAME | VARCHAR2 | (20) | Preparer first name | |
| LAST_NAME | VARCHAR2 | (30) | Preparer last name | |
| PHONE_NO | VARCHAR2 | (10) | Preparer phone number | |
| PHONE_EXT | VARCHAR2 | (5) | Preparer extension | |
| AGENCY_NAME_1 | VARCHAR2 | (40) | Agency name line 1 | |
| AGENCY_NAME_2 | VARCHAR2 | (40) | Agency name line 1 | |
| ADDRESS_1 | VARCHAR2 | (40) | Address line 1 | |
| ADDRESS_2 | VARCHAR2 | (40) | Address line 2 | |
| CITY | VARCHAR2 | (25) | City | |
| STATE | VARCHAR2 | (2) | State | |
| ZIP | VARCHAR2 | (10) | Zip code | |
| SUPERVISOR_NAME | VARCHAR2 | (40) | Supervisor name | |
| SUPERVISOR_PHONE | VARCHAR2 | (10) | Supervisor phone number | |
| SUPERVISOR_EXT | VARCHAR2 | (5) | Supervisor extension | |
| EMAIL_ADDRESS | VARCHAR2 | (50) | Preparer e-mail address | |
| FAX_NUM | VARCHAR2 | (10) | Preparer fax number | |
| MOTHERS_M_NAME | VARCHAR2 | (25) | Preparer mother's maiden name | |
| SUBMITTED_ID | NUMBER | (15) | Submitted identifier | |
| SUBMITTED_BY | VARCHAR2 | (25) | Submitted by | |
| SUBMITTED_STATUS | VARCHAR2 | (25) | Submitted status | |
| FACTS2_STATUS | VARCHAR2 | (25) | FACTS II status | |
| SUBMIT_FLAG | VARCHAR2 | (1) | Submit flag | |
| PURGE_FLAG | VARCHAR2 | (1) | Purge flag | |
| BULK_FLAG | VARCHAR2 | (1) | Bulk flag | |
| LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
| LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
| CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
| CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | ||
| LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
| BULK_FILE_SUB_ID | NUMBER | (15) | Bulk file submission identifier | |
| CURRENCY_CODE | VARCHAR2 | (15) | currency code of GL_BALANCES | |
| FOOT_NOTE_FLAG | VARCHAR2 | (1) | Footnote flag | |
| CONTACT_ID | NUMBER | (15) | Contact identifier | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
| REP_PERIOD_NUM | NUMBER | (15) | Not currently used |
Cut, paste (and edit) the following text to query this object:
SELECT TREASURY_SYMBOL_ID
, RUN_MODE
, SET_OF_BOOKS_ID
, PREPARER_ID
, CERTIFIED_ID
, REP_FYR
, REP_QTR
, FIRST_NAME
, LAST_NAME
, PHONE_NO
, PHONE_EXT
, AGENCY_NAME_1
, AGENCY_NAME_2
, ADDRESS_1
, ADDRESS_2
, CITY
, STATE
, ZIP
, SUPERVISOR_NAME
, SUPERVISOR_PHONE
, SUPERVISOR_EXT
, EMAIL_ADDRESS
, FAX_NUM
, MOTHERS_M_NAME
, SUBMITTED_ID
, SUBMITTED_BY
, SUBMITTED_STATUS
, FACTS2_STATUS
, SUBMIT_FLAG
, PURGE_FLAG
, BULK_FLAG
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, BULK_FILE_SUB_ID
, CURRENCY_CODE
, FOOT_NOTE_FLAG
, CONTACT_ID
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, REP_PERIOD_NUM
FROM FV.FV_FACTS_SUBMISSION;
FV.FV_FACTS_SUBMISSION does not reference any database object
FV.FV_FACTS_SUBMISSION is referenced by following:
FV
FV_FACTS_SUBMISSION#
|
|
|
|