GM_FFR_AET

(SQL Table)
 Index Back

Grants FFR XMLP Report

AET record for the Grants FFR XML Publisher Report.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 EFFDT Date(10) DATE Effective Date

Default Value: %date

3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
4 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
5 REPORT_DEFN_ID Character(12) VARCHAR2(12) NOT NULL Report Name (see PSXPRPTDEFN).
6 TMPLDEFN_ID Character(30) VARCHAR2(30) NOT NULL Template ID (see PSXPTMPLDEFN).
7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
8 ASOFDATE Date(10) DATE As of Date
9 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
10 SETID Character(5) VARCHAR2(5) NOT NULL SetID
11 SETID1 Character(5) VARCHAR2(5) NOT NULL SetID Value
12 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code SetID
13 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
14 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num

Prompt Table: GM_CA_DETAIL_VW

15 SPONSOR_ID Character(15) VARCHAR2(15) NOT NULL SPONSOR_ID
16 CERTIFY_OFFICIAL Character(11) VARCHAR2(11) NOT NULL Certifying Official

Prompt Table: PERSONAL_DATA

17 SUBMISSION_DATE Date(10) DATE Submission Date
18 BEGIN_DT Date(10) DATE Begin Date
19 END_DT Date(10) DATE End Date
20 FINAL_REPORT Character(1) VARCHAR2(1) NOT NULL Final Report Flag

Y/N Table Edit

Default Value: N

21 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
22 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
23 LOC_DOC_ID Character(30) VARCHAR2(30) NOT NULL Letter of Credit Document ID
24 AMT_1 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount1
25 AMT_2 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount2
26 AMT_3 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount3
27 AMT_4 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount4
28 AMT_5 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount5
29 AMT_6 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount6
30 AMT_7 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount7
31 AMT_8 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount8
32 AMT_9 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount9
33 AMT_10 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount10
34 AMT_11 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount11
35 AMT_12 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount12
36 AMT_13 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount13
37 AMT_14 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount14
38 AMT_15 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount15
39 AMT16 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount 16
40 DESCR_VALUE_1 Character(30) VARCHAR2(30) NOT NULL Description
41 DESCR30 Character(30) VARCHAR2(30) NOT NULL Description
42 COMMENTS Long Character CLOB Comment
43 NAME Character(50) VARCHAR2(50) NOT NULL Name
44 FLAG Character(1) VARCHAR2(1) NOT NULL Flag
N=No
Y=Yes
45 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
46 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
47 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
48 JOB_TITLE Character(50) VARCHAR2(50) NOT NULL Job Title
49 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
50 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
51 ATTR_CODE_VALUE Character(80) VARCHAR2(80) NOT NULL ATTR_CODE_VALUE
52 ORG_LEG_NAME Character(60) VARCHAR2(60) NOT NULL Organization Legal Name
53 GM_FFR_RPT_TYPE Character(1) VARCHAR2(1) NOT NULL Report Type
A=Annual
F=Final
Q=Quarterly
S=Semi-Annual
54 INSTID Character(5) VARCHAR2(5) NOT NULL Institution ID
55 GM_BEGIN_DT Date(10) DATE Begin Date
56 GM_END_DT Date(10) DATE End Date
57 PROG_INC_EXP_ADD Signed Number(28,3) DECIMAL(26,3) NOT NULL Income expended addition alt
58 FEDERAL_EIN_GM Character(30) VARCHAR2(30) NOT NULL Federal EIN
59 ACCOUNTING_BASIS Character(1) VARCHAR2(1) NOT NULL Accounting Basis
A=Accrual
C=Cash
60 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
61 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
62 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
63 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
64 CITY Character(30) VARCHAR2(30) NOT NULL City
65 STATE Character(6) VARCHAR2(6) NOT NULL State
66 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
67 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
68 PROG_INC_EXP_DED Signed Number(28,3) DECIMAL(26,3) NOT NULL Income expended deduction alt
69 TOTAL_FED_PROGRAM Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Federal Program Income
70 TOTAL_REC_SHARE Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Recipient Share Required
71 MULTIPLE_FLG Character(1) VARCHAR2(1) NOT NULL Reporting Multiple Grants

Y/N Table Edit

Default Value: N

72 DESCR Character(30) VARCHAR2(30) NOT NULL Description
73 FA_RATE_PCT Number(6,2) DECIMAL(5,2) NOT NULL FA_RATE_PCT
74 FA_BASE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL F&A Base Amount
75 LOC_REFERENCE_ID Character(10) VARCHAR2(10) NOT NULL Letter of Credit ID
76 REPORT_DUE_DATE Date(10) DATE Report Due Date
77 INDIRECT_EXPENSE Character(1) VARCHAR2(1) NOT NULL Show Indirect Expenses on FFR
78 AMT17 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount 17
79 AMT18 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount 18
80 REF_AWD_NUMBER Character(25) VARCHAR2(25) NOT NULL Reference Award Number