| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
RT_EFFDT |
Date(10) |
DATE |
The effective date for a given item of market rate data.
|
| 2 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 3 |
ACCOMPLISHMENT |
Character(8) |
VARCHAR2(8) NOT NULL |
Accomplishment
|
| 4 |
SCHOOL_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
School Code
|
| 5 |
MAJOR_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Major Code
|
| 6 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 7 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 8 |
DT_ISSUED |
Date(10) |
DATE |
Issue Date
|
| 9 |
DESCR1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Descr
|
| 10 |
DESCR2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Descr2
|
| 11 |
AWARD_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Honor/Award
|
| 12 |
INTERNAL_EXTERNAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows the user to indicate whether a given defined bank account is utilized for internal or ext
E=External
I=Internal
|
| 13 |
INSTID |
Character(5) |
VARCHAR2(5) NOT NULL |
Institution ID
|
| 14 |
EXT_ORG_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Org ID
|
| 15 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 16 |
PROPOSAL_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Proposal ID
|
| 17 |
SUB_PROP_NBR |
Character(15) |
VARCHAR2(15) NOT NULL |
SUB_PROP_NBR
|
| 18 |
PER_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Person Type
A=Applicant
C=Cobra Participant
D=GP Dependent/Beneficiary
E=Leased Worker
I=Independent Contractor
L=Time & Labor Contractor
M=Temporary Worker
N=Non HR Administered Employee
O=Other Non-Employee
P=Pension Payee
S=Stock Non-Employee
T=Training Non-Employee
U=Succession Candidate Non-Emplo
|
| 19 |
BIRTHDATE |
Date(10) |
DATE |
Date of Birth
|
| 20 |
MAR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Marital Status
C=Common-Law
D=Divorced
E=Separated
H=Head of Household
M=Married
S=Single
U=Unknown
W=Widowed
|
| 21 |
SEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Gender
F=Female
M=Male
U=Unknown
|
| 22 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 23 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 24 |
NAME_PREFIX |
Character(4) |
VARCHAR2(4) NOT NULL |
Name Prefix
1=Mr.
2=Mrs.
3=Ms.
|
| 25 |
NAME_SUFFIX |
Character(15) |
VARCHAR2(15) NOT NULL |
Name Suffix
|
| 26 |
NATIONAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
National ID
|
| 27 |
DISABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) a dependent is a disabled.
N=No
Y=Yes
|
| 28 |
ROW_NUMBER |
Number(3,0) |
SMALLINT NOT NULL |
Row_Number
|
| 29 |
CERT_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Certification Code
|
| 30 |
FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag
N=No
Y=Yes
|
| 31 |
APPROVAL_DATE |
Date(10) |
DATE |
Approval Date
|
| 32 |
ASSURANCE_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
Assurance Number
|
| 33 |
RA_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag
|
| 34 |
DATE_FROM |
Date(10) |
DATE |
Date From
|
| 35 |
APPROVAL_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
Approval Number
|
| 36 |
TOTAL_DIRECT_COST |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
TOTAL_DIRECT_COST
|
| 37 |
TOTAL_BUDGET_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
TOTAL_BUDGET_AMT
|
| 38 |
TOTAL_DIRECT_COST2 |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Total Direct Budget
|
| 39 |
TOTAL_BUDGET_AMT2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Budget
|
| 40 |
ETHNIC_GROUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Ethnic Group
1=White
2=Black/African American
3=Hispanic/Latino
4=Asian
5=American Indian/Alaska Native
6=Not Specified
7=Native Hawaiian/Oth Pac Island
|
| 41 |
EXEMPTION_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
Exemption Number
|
| 42 |
FULL_REVIEW |
Character(1) |
VARCHAR2(1) NOT NULL |
Full Review
|
| 43 |
EXPEDITED_REVIEW |
Character(1) |
VARCHAR2(1) NOT NULL |
Expedited Review
|
| 44 |
CITIZENSHIP_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Citizenship Status
1=Native
2=Naturalized
3=Alien Permanent
4=Alien Temporary
5=Permanent resident of U.S.
6=Working Visa
7=Canadian Citizen
8=Other
E=Not Entered
N=Not Indicated
|
| 45 |
ECTRANSID |
Character(15) |
VARCHAR2(15) NOT NULL |
Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
|
| 46 |
ECQUEUEINSTANCE |
Number(9,0) |
DECIMAL(9) NOT NULL |
Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
|
| 47 |
ECTRANSINOUTSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound
O=Outbound
|
| 48 |
AS_OF_DATE |
Date(10) |
DATE |
As of Date
|
| 49 |
FIRST_TIME_PI |
Character(1) |
VARCHAR2(1) NOT NULL |
First Time PI
|
| 50 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 51 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 52 |
VERSION_ID |
Character(7) |
VARCHAR2(7) NOT NULL |
Version ID
|
| 53 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 54 |
COST_SHARE_IN_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
COST_SHARE_IN_AMT
|
| 55 |
SPONSOR_FA_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
SPONSOR_FA_AMT
|
| 56 |
DISABILITY_CD_UK |
Character(3) |
VARCHAR2(3) NOT NULL |
Disability
DXT=Manual Dexterity
HRN=Hearing
LRN=Learning
MBL=Mobility
MNH=Mental Handicap
MNI=Mental Illness
OTH=Other
RSP=Respiratory
SPC=Speech
UNS=Unspecified
VSN=Vision
|
| 57 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
Prompt Table:
CA_CNTR_SRCH_VW
|
| 58 |
BILL_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer
Prompt Table:
BI_BILL_TO_VW
|
| 59 |
CONTRACT_LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Contract Line Num
|
| 60 |
BEGIN_DT |
Date(10) |
DATE |
Begin Date
|
| 61 |
END_DT |
Date(10) |
DATE |
End Date
|
| 62 |
AMOUNT_1 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount Work Field
|
| 63 |
AMOUNT_2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount Work Field
|
| 64 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 65 |
AMOUNT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 66 |
FA_RATE_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
FA_RATE_PCT
|
| 67 |
FA_BASE_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
F&A Base Amount
|
| 68 |
AMOUNT_APPLIED |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Applied
|
| 69 |
RESOURCE_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Amount
|
| 70 |
MONETARY_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
|
| 71 |
BUSINESS_UNIT_PROP |
Character(5) |
VARCHAR2(5) NOT NULL |
Proposal Business Unit
|
| 72 |
PROPOSAL_ID_TO |
Character(25) |
VARCHAR2(25) NOT NULL |
Proposal ID
|
| 73 |
VERSION_ID_TO |
Character(7) |
VARCHAR2(7) NOT NULL |
Version ID To
|
| 74 |
SUB_PROP_NBR_TO |
Character(15) |
VARCHAR2(15) NOT NULL |
Sub Proposal ID To
|
| 75 |
ROW_NUMBER_TO |
Number(3,0) |
SMALLINT NOT NULL |
Personnel/Professional Number
|
| 76 |
APPT_TYPE_MTH_CAL |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Calendar Appointment Months
|
| 77 |
APPT_TYPE_MTH_ACAD |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Academic Appointment Months
|
| 78 |
APPT_TYPE_MTH_SUMR |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Summer Appointment Months
|
| 79 |
REF_AWD_NUMBER |
Character(25) |
VARCHAR2(25) NOT NULL |
Reference Award Number
|
| 80 |
COUNT_1 |
Number(3,0) |
SMALLINT NOT NULL |
Count Work Field
|
| 81 |
COUNT_2 |
Number(3,0) |
SMALLINT NOT NULL |
Count Work Field
|
| 82 |
LOC_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Letter of Credit
|
| 83 |
CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
|
| 84 |
LOC_REFERENCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Letter of Credit ID
|
| 85 |
INFO_FLD1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Information Field 1
|
| 86 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 87 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 88 |
AMT1 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used in Virtual Approver to store the various rule amounts that go on each approval step
|
| 89 |
AMT2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used in Virtual Approver to store the various rule amounts that go on each approval step
|
| 90 |
TAXPAYER_ID |
Character(14) |
VARCHAR2(14) NOT NULL |
Taxpayer ID
|
| 91 |
FEDERAL_EIN_GM |
Character(30) |
VARCHAR2(30) NOT NULL |
Federal EIN
|
| 92 |
STATE_OTHER |
Character(6) |
VARCHAR2(6) NOT NULL |
State Other
|
| 93 |
COUNTRY_OTHER |
Character(3) |
VARCHAR2(3) NOT NULL |
Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT
|
| 94 |
EMPLID_OLD |
Character(11) |
VARCHAR2(11) NOT NULL |
Previous Employee ID
|
| 95 |
PREV_CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Previous Project/Grant
|
| 96 |
BUSINESS_UNIT_AWD |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 97 |
REF_AWD_NUM2 |
Character(25) |
VARCHAR2(25) NOT NULL |
Reference Award
|
| 98 |
BUDGET_CATEGORY |
Character(15) |
VARCHAR2(15) NOT NULL |
BUDGET_CATEGORY
|
| 99 |
BUDGET_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
BUDGET_ID
|
| 100 |
BUDGET_PERIOD_GM |
Number(3,0) |
SMALLINT NOT NULL |
BUDGET_PERIOD_GM
|
| 101 |
BUDGET_LN |
Number(6,0) |
INTEGER NOT NULL |
BUDGET_LN
|
| 102 |
FA_RATE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
FA_RATE_TYPE
|
| 103 |
DATE_DIFF |
Number(11,0) |
DECIMAL(11) NOT NULL |
Date Different
|
| 104 |
TOTAL_BASE |
Number(3,0) |
SMALLINT NOT NULL |
Total Base Currencies
|
| 105 |
RATE_EFFDT |
Date(10) |
DATE |
Rate Effective Date
|
| 106 |
DAYS_ELAPSED |
Number(4,0) |
SMALLINT NOT NULL |
Days Elapsed
|
| 107 |
BEGIN_DEPR_DT |
Date(10) |
DATE |
Begin Depr Date
|
| 108 |
END_DEPR_DT |
Date(10) |
DATE |
End Depreciation Date
|
| 109 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 110 |
AMT3 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used in Virtual Approver to store the various rule amounts that go on each approval step
|
| 111 |
AMT_TOTAL1 |
Number(18,4) |
DECIMAL(17,4) NOT NULL |
Total Amount of Lines
|
| 112 |
SPONSOR_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
SPONSOR_AMT
|
| 113 |
LANG_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
CFR=Canadian French
DUT=Dutch
ENG=English
ESP=Spanish
FRA=French
GER=German
INE=International English
ITA=Italian
JPN=Japanese
POR=Portuguese
|
| 114 |
LOC_DOC_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Letter of Credit Document ID
|
| 115 |
NIH_IPF_NBR |
Character(14) |
VARCHAR2(14) NOT NULL |
NIH IPF Number
|
| 116 |
ASSURANCE_NBR2 |
Character(20) |
VARCHAR2(20) NOT NULL |
Assurance Number
|
| 117 |
FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 118 |
LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 119 |
MIDDLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Middle Name
|
| 120 |
DESCR120 |
Character(120) |
VARCHAR2(120) NOT NULL |
Description
|
| 121 |
SUBMIT_DTTM |
DateTime(26) |
TIMESTAMP |
Report Submitted On - DateTime
|
| 122 |
DESCR_2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 123 |
CREDENTIAL |
Character(60) |
VARCHAR2(60) NOT NULL |
Credentials
|
| 124 |
ALASK_SER_INST |
Character(1) |
VARCHAR2(1) NOT NULL |
Alaska Native Serving Institu
|
| 125 |
COOPER_EXTEN |
Character(1) |
VARCHAR2(1) NOT NULL |
Cooperative Extension Service
|
| 126 |
HISPAN_SEV_INST |
Character(1) |
VARCHAR2(1) NOT NULL |
Hispanic Serving Institution
|
| 127 |
HISTOR_BLK_UNV |
Character(1) |
VARCHAR2(1) NOT NULL |
Historically Black College
|
| 128 |
MIN_SEV_INST |
Character(1) |
VARCHAR2(1) NOT NULL |
Minority Serving Institution
|
| 129 |
NAT_HAW_INST |
Character(1) |
VARCHAR2(1) NOT NULL |
Native Hawaiian Serving Instit
|
| 130 |
PUB_NO_PROF_COMCOL |
Character(1) |
VARCHAR2(1) NOT NULL |
Public Nonprofit College
|
| 131 |
PUB_SECON_SCHL |
Character(1) |
VARCHAR2(1) NOT NULL |
Public Secondary School
|
| 132 |
SCH_OF_FORESTRY |
Character(1) |
VARCHAR2(1) NOT NULL |
School of Forestry
|
| 133 |
STATE_AGR_EXP_ST |
Character(1) |
VARCHAR2(1) NOT NULL |
State Agricultural Experiment
|
| 134 |
TRIBAL_COLLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Tribal College
|
| 135 |
VETER_SCH_COLLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Veterinary Scholar College
|
| 136 |
HHS_PMS_YN |
Character(1) |
VARCHAR2(1) NOT NULL |
DHHS -PMS
|
| 137 |
DHHS_PMS_PIN |
Character(8) |
VARCHAR2(8) NOT NULL |
DHHS-PMS PIN
|
| 138 |
INS_KEYWORD |
Character(100) |
VARCHAR2(100) NOT NULL |
KeyWords
|
| 139 |
REV_PND_IACUC |
Character(1) |
VARCHAR2(1) NOT NULL |
IACUCA Review
|
| 140 |
ORG_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
OrganizationType
|
| 141 |
ORG_TYPE_DESC |
Character(60) |
VARCHAR2(60) NOT NULL |
Description
|
| 142 |
COMMENTS |
Long Character |
CLOB |
Comment
|
| 143 |
DIS_HEARING |
Character(1) |
VARCHAR2(1) NOT NULL |
Hearing
|
| 144 |
DIS_VISION |
Character(1) |
VARCHAR2(1) NOT NULL |
Vision
|
| 145 |
DIS_OTHER |
Character(1) |
VARCHAR2(1) NOT NULL |
Other
|
| 146 |
DIS_NONE |
Character(1) |
VARCHAR2(1) NOT NULL |
None
|
| 147 |
DIS_DONT_PROVIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Do Not Wish to Provide
|
| 148 |
DESCR30 |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 149 |
USA_AGY_NAME |
Character(80) |
VARCHAR2(80) NOT NULL |
US Government Agency Name
|
| 150 |
USA_GOV_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
US Government Agency
|
| 151 |
NSPIRES_USER_NAME |
Character(12) |
VARCHAR2(12) NOT NULL |
NSPIRES User Name
|
| 152 |
DIS_MOB_ORTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Mobility/Orthopedic Impairment
|
| 153 |
ADD_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Additional Applicant Type
|
| 154 |
DESCR100 |
Character(100) |
VARCHAR2(100) NOT NULL |
Length 100 Description
|
| 155 |
PRE_TRACK_NUM |
Character(240) |
VARCHAR2(240) NOT NULL |
Tracking Number
|
| 156 |
TRACKING_NBR |
Character(30) |
VARCHAR2(30) NOT NULL |
Tracking Number
|
| 157 |
STATE_FORMAT |
Character(40) |
VARCHAR2(40) NOT NULL |
STATE FORMAT
|
| 158 |
COUNTRY_FORMAT |
Character(40) |
VARCHAR2(40) NOT NULL |
COUNTRY FORMAT
|
| 159 |
AFFILIATE_USE |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Affiliate
|
| 160 |
ALLOWABLE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allowable Cost?
|
| 161 |
ANTICIPATED_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Allowable Aniticipated Amount
|
| 162 |
CONT_ALLOW_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Allowable Construction Pct
|
| 163 |
CONT_NO_ALLW_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Not allowable Construction Pct
|
| 164 |
COST_CLASSIFICATN |
Character(100) |
VARCHAR2(100) NOT NULL |
Cost Classification
|
| 165 |
FED_SHARE_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Federal Share Percentage
|
| 166 |
GM_501_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Have 501(c)(3) status
|
| 167 |
GM_ANNL_BUDGET |
Character(3) |
VARCHAR2(3) NOT NULL |
Size of the annual budget
A=Less Than $150,000
B=$150,000 - $299,999
C=$300,000 - $499,999
D=$500,000 - $999,999
E=$1,000,000 - $4,999,999
F=$5,000,000 or more
|
| 168 |
GM_AWARDED |
Character(1) |
VARCHAR2(1) NOT NULL |
Ever received grant/contract
|
| 169 |
GM_FAITH_BASED |
Character(1) |
VARCHAR2(1) NOT NULL |
A faith-based organization
|
| 170 |
GM_FULL_TIME_EE |
Character(3) |
VARCHAR2(3) NOT NULL |
Full-time equivalent employees
A=3 or fewer
B=4-5
C=6-14
D=15-50
E=51-100
F=Over 100
|
| 171 |
GM_SECULAR |
Character(1) |
VARCHAR2(1) NOT NULL |
A secular organization
|
| 172 |
NO_ALLOW_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Not Allowable Anticipat Amount
|