AM_FDRLPOST_AET

(SQL Table)
Index Back

AM Federal Post

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
3 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once
4 PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
6 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
7 AM_FDRL_ASSET_GRP Character(10) VARCHAR2(10) NOT NULL AM Federal Asset Group field.
8 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
9 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.
10 BEGIN_DT_CAL_START Date(10) DATE Calendar Begin Date for Start
11 END_DT_CAL_END Date(10) DATE Calendar End Date for End
12 SETID Character(5) VARCHAR2(5) NOT NULL SetID
13 RULE_SETID Character(5) VARCHAR2(5) NOT NULL Rule Setid
14 SETID_CF Character(5) VARCHAR2(5) NOT NULL KK Control Chartfield SetID
15 PREV_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Previous Business Unit
16 AM_FDRL_GRP_PREV Character(10) VARCHAR2(10) NOT NULL AM Federal Asset Group field.
17 FIELDNAME_FC Character(18) VARCHAR2(18) NOT NULL Fieldname for Fund Code.
18 AM_FDRL_ROWS Number(15,0) DECIMAL(15) NOT NULL Number of Rows fetched.
19 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
20 AM_NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix