data-raw/code-chunks/chunks/CHUNKS-F9-P07-T00-DIR-TRUST-KEY.R
In Nonprofit-Open-Data-Collective/irs990efile: Convert IRS 990 XML files to a relational database.
#' @title
#' Build table F9-P07-T00-DIR-TRUST-KEY
#'
#' @description
#' Generate a 1:1 table for the relational database.
#'
#' @export
BUILD_F9_P07_T00_DIR_TRUST_KEY <- function( doc, url )
{
####----------------------------------------------------
#### KEYS
####----------------------------------------------------
## OBJECT ID
OBJECTID <- get_object_id( url )
## URL
URL <- url
## RETURN VERSION
RETURN_VERSION <- xml2::xml_attr( doc, attr='returnVersion' )
## VARIABLE NAME: ORG_EIN
## DESCRIPTION: Orgainization Employer Identification Number (EIN)
## LOCATION: F990-PC-PART-00-SECTION-D
## TABLE: F9-P00-T00-HEADER
## VARIABLE TYPE: numeric
## PRODUCTION RULE: NA
ORG_EIN <- xml_text( xml_find_all( doc, '/Return/ReturnHeader/Filer/EIN' ) )
## VARIABLE NAME: ORG_NAME_L1
## DESCRIPTION: Name of Filing Organization (line 1)
## LOCATION: F990-PC-PART-00-SECTION-C
## TABLE: F9-P00-T00-HEADER
## VARIABLE TYPE: text
## PRODUCTION RULE: NA
V1 <- '//Return/ReturnHeader/Filer/Name/BusinessNameLine1'
V2 <- '//Return/ReturnHeader/Filer/BusinessName/BusinessNameLine1'
V3 <- '//Return/ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt'
TEMP_ORG_NAME_L1 <- paste( V1, V2, V3 , sep='|' )
ORG_NAME_L1 <- xml_text( xml_find_all( doc, TEMP_ORG_NAME_L1 ) )
## VARIABLE NAME: ORG_NAME_L2
## DESCRIPTION: Name of Filing Organization (line 2)
## LOCATION: F990-PC-PART-00-SECTION-C
## TABLE: F9-P00-T00-HEADER
## VARIABLE TYPE: text
## PRODUCTION RULE: NA
V1 <- '//Return/ReturnHeader/Filer/Name/BusinessNameLine2'
V2 <- '//Return/ReturnHeader/Filer/BusinessName/BusinessNameLine2'
V3 <- '//Return/ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt'
TEMP_ORG_NAME_L2 <- paste( V1, V2, V3 , sep='|' )
ORG_NAME_L2 <- xml_text( xml_find_all( doc, TEMP_ORG_NAME_L2 ) )
## VARIABLE NAME: RETURN_TYPE
## DESCRIPTION: Return type
## LOCATION: F990-PC-PART-00-LINE-00
## TABLE: F9-P00-T00-HEADER
## VARIABLE TYPE: text
## PRODUCTION RULE: NA
V1 <- '//Return/ReturnHeader/ReturnType'
V2 <- '//Return/ReturnHeader/ReturnTypeCd'
TEMP_RETURN_TYPE <- paste( V1, V2 , sep='|' )
RETURN_TYPE <- xml_text( xml_find_all( doc, TEMP_RETURN_TYPE ) )
## VARIABLE NAME: TAX_YEAR
## DESCRIPTION: Tax year
## LOCATION: F990-PC-PART-00-SECTION-A
## TABLE: F9-P00-T00-HEADER
## VARIABLE TYPE: date
## PRODUCTION RULE: NA
V1 <- '//Return/ReturnHeader/TaxYear'
V2 <- '//Return/ReturnHeader/TaxYr'
TEMP_TAX_YEAR <- paste( V1, V2 , sep='|' )
TAX_YEAR <- xml_text( xml_find_all( doc, TEMP_TAX_YEAR ) )
######----------------------------------------------------
######
###### 1:1 TABLE VARIABLES
######
######----------------------------------------------------
## VARIABLE NAME: F9_07_COMP_KONTR_NUM_GT_100K
## DESCRIPTION: Total number of independent contractors who received 100K+ from org
## LOCATION: F990-PC-PART-07-SECTION-B-LINE-02
## TABLE: F9-P07-T00-DIR-TRUST-KEY
## VARIABLE TYPE: numeric
## PRODUCTION RULE: NA
V1 <- '//Return/ReturnData/IRS990/CntrctRcvdGreaterThan100KCnt'
V2 <- '//Return/ReturnData/IRS990/Form990PartVIISectionB/NumberOfContractorsGT100K'
V3 <- '//Return/ReturnData/IRS990/NumberOfContractorsGT100K'
V4 <- '//Return/ReturnData/IRS990EZ/CntrctRcvdGreaterThan100KCnt'
V5 <- '//Return/ReturnData/IRS990EZ/TotNumCntrctPdOver100KProfSer'
V_COMP_KONTR_NUM_GT_100K <- paste( V1, V2, V3, V4, V5 , sep='|' )
F9_07_COMP_KONTR_NUM_GT_100K <- xml_text( xml_find_all( doc, V_COMP_KONTR_NUM_GT_100K ) )
## VARIABLE NAME: F9_07_COMP_DTK_COMP_OTH_SOURCE_X
## DESCRIPTION: Compensation from other sources? (F990-PC-PART-07-SECTION-A: F990-EZ-PART-04-PART-06-LINE-50-CONBINED)
## LOCATION: F990-PC-PART-07-SECTION-A-LINE-05
## TABLE: F9-P07-T00-DIR-TRUST-KEY
## VARIABLE TYPE: checkbox
## PRODUCTION RULE: NA
V1 <- '//Return/ReturnData/IRS990/CompensationFromOtherSources'
V2 <- '//Return/ReturnData/IRS990/CompensationFromOtherSrcsInd'
V3 <- '//Return/ReturnData/IRS990/Form990PartVIISectionA/CompensationFromOtherSources'
V_COMP_DTK_COMP_OTH_SOURCE_X <- paste( V1, V2, V3 , sep='|' )
F9_07_COMP_DTK_COMP_OTH_SOURCE_X <- xml_text( xml_find_all( doc, V_COMP_DTK_COMP_OTH_SOURCE_X ) )
## VARIABLE NAME: F9_07_COMP_DTK_FORMER_LISTED_X
## DESCRIPTION: Is a former officer, director, or trustee listed in the compensation table in Sectin A Line 1a? (F990-PC-PART-07-SECTION-A: F990-EZ-PART-04-PART-06-LINE-50-CONBINED)
## LOCATION: F990-PC-PART-07-SECTION-A-LINE-03
## TABLE: F9-P07-T00-DIR-TRUST-KEY
## VARIABLE TYPE: checkbox
## PRODUCTION RULE: NA
V1 <- '//Return/ReturnData/IRS990/Form990PartVIISectionA/FormersListedIn1A'
V2 <- '//Return/ReturnData/IRS990/FormerOfcrEmployeesListedInd'
V3 <- '//Return/ReturnData/IRS990/FormersListed'
V_COMP_DTK_FORMER_LISTED_X <- paste( V1, V2, V3 , sep='|' )
F9_07_COMP_DTK_FORMER_LISTED_X <- xml_text( xml_find_all( doc, V_COMP_DTK_FORMER_LISTED_X ) )
## VARIABLE NAME: F9_07_COMP_DTK_COMP_GT_150K_X
## DESCRIPTION: Line1a; total greater than $150K? (F990-PC-PART-07-SECTION-A: F990-EZ-PART-04-PART-06-LINE-50-CONBINED)
## LOCATION: F990-PC-PART-07-SECTION-A-LINE-04
## TABLE: F9-P07-T00-DIR-TRUST-KEY
## VARIABLE TYPE: checkbox
## PRODUCTION RULE: NA
V1 <- '//Return/ReturnData/IRS990/Form990PartVIISectionA/Line1ATotalGT150K'
V2 <- '//Return/ReturnData/IRS990/TotalCompGreaterThan150KInd'
V3 <- '//Return/ReturnData/IRS990/TotalCompGT150K'
V_COMP_DTK_COMP_GT_150K_X <- paste( V1, V2, V3 , sep='|' )
F9_07_COMP_DTK_COMP_GT_150K_X <- xml_text( xml_find_all( doc, V_COMP_DTK_COMP_GT_150K_X ) )
## VARIABLE NAME: F9_07_COMP_DTK_NO_LISTED_X
## DESCRIPTION: No listed persons compensated (F990-PC-PART-07-SECTION-A: F990-EZ-PART-04-PART-06-LINE-50-CONBINED)
## LOCATION: F990-PC-PART-07-SECTION-A-LINE-01A
## TABLE: F9-P07-T00-DIR-TRUST-KEY
## VARIABLE TYPE: checkbox
## PRODUCTION RULE: NA
V1 <- '//Return/ReturnData/IRS990/Form990PartVIISectionA/NoListedPersonsCompensated'
V2 <- '//Return/ReturnData/IRS990/NoListedPersonsCompensated'
V3 <- '//Return/ReturnData/IRS990/NoListedPersonsCompensatedInd'
V_COMP_DTK_NO_LISTED_X <- paste( V1, V2, V3 , sep='|' )
F9_07_COMP_DTK_NO_LISTED_X <- xml_text( xml_find_all( doc, V_COMP_DTK_NO_LISTED_X ) )
## VARIABLE NAME: F9_07_COMP_DTK_NUM_GT_100K
## DESCRIPTION: Number individuals greater than $100K (F990-PC-PART-07-SECTION-A: F990-EZ-PART-04-PART-06-LINE-50-CONBINED)
## LOCATION: F990-PC-PART-07-SECTION-A-LINE-02
## TABLE: F9-P07-T00-DIR-TRUST-KEY
## VARIABLE TYPE: numeric
## PRODUCTION RULE: NA
V1 <- '//Return/ReturnData/IRS990/Form990PartVIISectionA/NumberIndividualsGT100K'
V2 <- '//Return/ReturnData/IRS990/IndivRcvdGreaterThan100KCnt'
V3 <- '//Return/ReturnData/IRS990/NumberIndividualsGT100K'
V_COMP_DTK_NUM_GT_100K <- paste( V1, V2, V3 , sep='|' )
F9_07_COMP_DTK_NUM_GT_100K <- xml_text( xml_find_all( doc, V_COMP_DTK_NUM_GT_100K ) )
## VARIABLE NAME: F9_07_COMP_DTK_COMP_ORG_SUBTOT
## DESCRIPTION: Total; column D (F990-PC-PART-07-SECTION-A: F990-EZ-PART-04-PART-06-LINE-50-CONBINED)
## LOCATION: F990-PC-PART-07-SECTION-A-LINE-01B-COL-D
## TABLE: F9-P07-T00-DIR-TRUST-KEY
## VARIABLE TYPE: numeric
## PRODUCTION RULE: NA
F9_07_COMP_DTK_COMP_ORG_SUBTOT <- xml_text( xml_find_all( doc, '/Return/ReturnData/IRS990/Form990PartVIISectionA/TotalColumnD' ) )
## VARIABLE NAME: F9_07_COMP_DTK_COMP_RLTD_SUBTOT
## DESCRIPTION: Total; column E (F990-PC-PART-07-SECTION-A: F990-EZ-PART-04-PART-06-LINE-50-CONBINED)
## LOCATION: F990-PC-PART-07-SECTION-A-LINE-01B-COL-E
## TABLE: F9-P07-T00-DIR-TRUST-KEY
## VARIABLE TYPE: numeric
## PRODUCTION RULE: NA
F9_07_COMP_DTK_COMP_RLTD_SUBTOT <- xml_text( xml_find_all( doc, '/Return/ReturnData/IRS990/Form990PartVIISectionA/TotalColumnE' ) )
## VARIABLE NAME: F9_07_COMP_DTK_COMP_OTH_SUBTOT
## DESCRIPTION: Total; column F (F990-PC-PART-07-SECTION-A: F990-EZ-PART-04-PART-06-LINE-50-CONBINED)
## LOCATION: F990-PC-PART-07-SECTION-A-LINE-01B-COL-F
## TABLE: F9-P07-T00-DIR-TRUST-KEY
## VARIABLE TYPE: numeric
## PRODUCTION RULE: NA
F9_07_COMP_DTK_COMP_OTH_SUBTOT <- xml_text( xml_find_all( doc, '/Return/ReturnData/IRS990/Form990PartVIISectionA/TotalColumnF' ) )
## VARIABLE NAME: F9_07_INFO_SCHED_O_X
## DESCRIPTION: Schedule O contains a response to a question in Part VII
## LOCATION: F990-PC-PART-07-LINE-00
## TABLE: F9-P07-T00-DIR-TRUST-KEY
## VARIABLE TYPE: checkbox
## PRODUCTION RULE: NA
V1 <- '//Return/ReturnData/IRS990/InfoInScheduleOPartVII'
V2 <- '//Return/ReturnData/IRS990/InfoInScheduleOPartVIIInd'
V3 <- '//Return/ReturnData/IRS990EZ/InfoInScheduleOPartIV'
V4 <- '//Return/ReturnData/IRS990EZ/InfoInScheduleOPartIVInd'
V5 <- '//Return/ReturnData/IRS990EZ/InfoInScheduleOPartVII'
V6 <- '//Return/ReturnData/IRS990EZ/InfoInScheduleOPartVIIInd'
V_INFO_SCHED_O_X <- paste( V1, V2, V3, V4, V5, V6 , sep='|' )
F9_07_INFO_SCHED_O_X <- xml_text( xml_find_all( doc, V_INFO_SCHED_O_X ) )
## VARIABLE NAME: F9_07_COMP_DTK_COMP_OTH_TOT
## DESCRIPTION: Total, column F (F990-PC-PART-07-SECTION-A: F990-EZ-PART-04-PART-06-LINE-50-CONBINED)
## LOCATION: F990-PC-PART-07-SECTION-A-LINE-01D-COL-F
## TABLE: F9-P07-T00-DIR-TRUST-KEY
## VARIABLE TYPE: numeric
## PRODUCTION RULE: NA
V1 <- '//Return/ReturnData/IRS990/TotalOtherCompensation'
V2 <- '//Return/ReturnData/IRS990/TotalOtherCompensationAmt'
V_COMP_DTK_COMP_OTH_TOT <- paste( V1, V2 , sep='|' )
F9_07_COMP_DTK_COMP_OTH_TOT <- xml_text( xml_find_all( doc, V_COMP_DTK_COMP_OTH_TOT ) )
## VARIABLE NAME: F9_07_COMP_DTK_COMP_RLTD_TOT
## DESCRIPTION: Total, column E (F990-PC-PART-07-SECTION-A: F990-EZ-PART-04-PART-06-LINE-50-CONBINED)
## LOCATION: F990-PC-PART-07-SECTION-A-LINE-01D-COL-E
## TABLE: F9-P07-T00-DIR-TRUST-KEY
## VARIABLE TYPE: numeric
## PRODUCTION RULE: NA
V1 <- '//Return/ReturnData/IRS990/TotalReportableCompFrmRltdOrgs'
V2 <- '//Return/ReturnData/IRS990/TotReportableCompRltdOrgAmt'
V_COMP_DTK_COMP_RLTD_TOT <- paste( V1, V2 , sep='|' )
F9_07_COMP_DTK_COMP_RLTD_TOT <- xml_text( xml_find_all( doc, V_COMP_DTK_COMP_RLTD_TOT ) )
## VARIABLE NAME: F9_07_COMP_DTK_COMP_ORG_TOT
## DESCRIPTION: Total, column D (F990-PC-PART-07-SECTION-A: F990-EZ-PART-04-PART-06-LINE-50-CONBINED)
## LOCATION: F990-PC-PART-07-SECTION-A-LINE-01D-COL-D
## TABLE: F9-P07-T00-DIR-TRUST-KEY
## VARIABLE TYPE: numeric
## PRODUCTION RULE: NA
V1 <- '//Return/ReturnData/IRS990/TotalReportableCompFromOrg'
V2 <- '//Return/ReturnData/IRS990/TotalReportableCompFromOrgAmt'
V_COMP_DTK_COMP_ORG_TOT <- paste( V1, V2 , sep='|' )
F9_07_COMP_DTK_COMP_ORG_TOT <- xml_text( xml_find_all( doc, V_COMP_DTK_COMP_ORG_TOT ) )
## VARIABLE NAME: F9_07_SCHED_A_FILED_X
## DESCRIPTION: Did the organization complete Schedule A?
## LOCATION: F990-EZ-PART-06-LINE-52
## TABLE: F9-P07-T00-DIR-TRUST-KEY
## VARIABLE TYPE: checkbox
## PRODUCTION RULE: NA
V1 <- '//Return/ReturnData/IRS990EZ/FiledScheduleA'
V2 <- '//Return/ReturnData/IRS990EZ/FiledScheduleAInd'
V_SCHED_A_FILED_X <- paste( V1, V2 , sep='|' )
F9_07_SCHED_A_FILED_X <- xml_text( xml_find_all( doc, V_SCHED_A_FILED_X ) )
## VARIABLE NAME: F9_07_COMP_DTK_NUM_GT_100K_HCE
## DESCRIPTION: Total number of other employees paid over $100;000 (F990-PC-PART-07-SECTION-A: F990-EZ-PART-04-PART-06-LINE-50-CONBINED)
## LOCATION: F990-EZ-PART-06-LINE-50F
## TABLE: F9-P07-T00-DIR-TRUST-KEY
## VARIABLE TYPE: numeric
## PRODUCTION RULE: NA
V1 <- '//Return/ReturnData/IRS990EZ/OtherEmployeePaidOver100kCnt'
V2 <- '//Return/ReturnData/IRS990EZ/TotNumberOfOthEmplPaidOver100k'
V_COMP_DTK_NUM_GT_100K_HCE <- paste( V1, V2 , sep='|' )
F9_07_COMP_DTK_NUM_GT_100K_HCE <- xml_text( xml_find_all( doc, V_COMP_DTK_NUM_GT_100K_HCE ) )
var.list <-
namedList(OBJECTID,URL,ORG_EIN,ORG_NAME_L1,ORG_NAME_L2,RETURN_TYPE,TAX_YEAR,F9_07_COMP_KONTR_NUM_GT_100K,F9_07_COMP_DTK_COMP_OTH_SOURCE_X,F9_07_COMP_DTK_FORMER_LISTED_X,F9_07_COMP_DTK_COMP_GT_150K_X,F9_07_COMP_DTK_NO_LISTED_X,F9_07_COMP_DTK_NUM_GT_100K,F9_07_COMP_DTK_COMP_ORG_SUBTOT,F9_07_COMP_DTK_COMP_RLTD_SUBTOT,F9_07_COMP_DTK_COMP_OTH_SUBTOT,F9_07_INFO_SCHED_O_X,F9_07_COMP_DTK_COMP_OTH_TOT,F9_07_COMP_DTK_COMP_RLTD_TOT,F9_07_COMP_DTK_COMP_ORG_TOT,F9_07_SCHED_A_FILED_X,F9_07_COMP_DTK_NUM_GT_100K_HCE)
df <- as.data.frame( var.list )
return( df )
}
Nonprofit-Open-Data-Collective/irs990efile documentation built on Dec. 25, 2024, 5:30 p.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
#' @title
#' Build table F9-P07-T00-DIR-TRUST-KEY
#'
#' @description
#' Generate a 1:1 table for the relational database.
#'
#' @export
BUILD_F9_P07_T00_DIR_TRUST_KEY <- function( doc, url )
{
####----------------------------------------------------
#### KEYS
####----------------------------------------------------
## OBJECT ID
OBJECTID <- get_object_id( url )
## URL
URL <- url
## RETURN VERSION
RETURN_VERSION <- xml2::xml_attr( doc, attr='returnVersion' )
## VARIABLE NAME: ORG_EIN
## DESCRIPTION: Orgainization Employer Identification Number (EIN)
## LOCATION: F990-PC-PART-00-SECTION-D
## TABLE: F9-P00-T00-HEADER
## VARIABLE TYPE: numeric
## PRODUCTION RULE: NA
ORG_EIN <- xml_text( xml_find_all( doc, '/Return/ReturnHeader/Filer/EIN' ) )
## VARIABLE NAME: ORG_NAME_L1
## DESCRIPTION: Name of Filing Organization (line 1)
## LOCATION: F990-PC-PART-00-SECTION-C
## TABLE: F9-P00-T00-HEADER
## VARIABLE TYPE: text
## PRODUCTION RULE: NA
V1 <- '//Return/ReturnHeader/Filer/Name/BusinessNameLine1'
V2 <- '//Return/ReturnHeader/Filer/BusinessName/BusinessNameLine1'
V3 <- '//Return/ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt'
TEMP_ORG_NAME_L1 <- paste( V1, V2, V3 , sep='|' )
ORG_NAME_L1 <- xml_text( xml_find_all( doc, TEMP_ORG_NAME_L1 ) )
## VARIABLE NAME: ORG_NAME_L2
## DESCRIPTION: Name of Filing Organization (line 2)
## LOCATION: F990-PC-PART-00-SECTION-C
## TABLE: F9-P00-T00-HEADER
## VARIABLE TYPE: text
## PRODUCTION RULE: NA
V1 <- '//Return/ReturnHeader/Filer/Name/BusinessNameLine2'
V2 <- '//Return/ReturnHeader/Filer/BusinessName/BusinessNameLine2'
V3 <- '//Return/ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt'
TEMP_ORG_NAME_L2 <- paste( V1, V2, V3 , sep='|' )
ORG_NAME_L2 <- xml_text( xml_find_all( doc, TEMP_ORG_NAME_L2 ) )
## VARIABLE NAME: RETURN_TYPE
## DESCRIPTION: Return type
## LOCATION: F990-PC-PART-00-LINE-00
## TABLE: F9-P00-T00-HEADER
## VARIABLE TYPE: text
## PRODUCTION RULE: NA
V1 <- '//Return/ReturnHeader/ReturnType'
V2 <- '//Return/ReturnHeader/ReturnTypeCd'
TEMP_RETURN_TYPE <- paste( V1, V2 , sep='|' )
RETURN_TYPE <- xml_text( xml_find_all( doc, TEMP_RETURN_TYPE ) )
## VARIABLE NAME: TAX_YEAR
## DESCRIPTION: Tax year
## LOCATION: F990-PC-PART-00-SECTION-A
## TABLE: F9-P00-T00-HEADER
## VARIABLE TYPE: date
## PRODUCTION RULE: NA
V1 <- '//Return/ReturnHeader/TaxYear'
V2 <- '//Return/ReturnHeader/TaxYr'
TEMP_TAX_YEAR <- paste( V1, V2 , sep='|' )
TAX_YEAR <- xml_text( xml_find_all( doc, TEMP_TAX_YEAR ) )
######----------------------------------------------------
######
###### 1:1 TABLE VARIABLES
######
######----------------------------------------------------
## VARIABLE NAME: F9_07_COMP_KONTR_NUM_GT_100K
## DESCRIPTION: Total number of independent contractors who received 100K+ from org
## LOCATION: F990-PC-PART-07-SECTION-B-LINE-02
## TABLE: F9-P07-T00-DIR-TRUST-KEY
## VARIABLE TYPE: numeric
## PRODUCTION RULE: NA
V1 <- '//Return/ReturnData/IRS990/CntrctRcvdGreaterThan100KCnt'
V2 <- '//Return/ReturnData/IRS990/Form990PartVIISectionB/NumberOfContractorsGT100K'
V3 <- '//Return/ReturnData/IRS990/NumberOfContractorsGT100K'
V4 <- '//Return/ReturnData/IRS990EZ/CntrctRcvdGreaterThan100KCnt'
V5 <- '//Return/ReturnData/IRS990EZ/TotNumCntrctPdOver100KProfSer'
V_COMP_KONTR_NUM_GT_100K <- paste( V1, V2, V3, V4, V5 , sep='|' )
F9_07_COMP_KONTR_NUM_GT_100K <- xml_text( xml_find_all( doc, V_COMP_KONTR_NUM_GT_100K ) )
## VARIABLE NAME: F9_07_COMP_DTK_COMP_OTH_SOURCE_X
## DESCRIPTION: Compensation from other sources? (F990-PC-PART-07-SECTION-A: F990-EZ-PART-04-PART-06-LINE-50-CONBINED)
## LOCATION: F990-PC-PART-07-SECTION-A-LINE-05
## TABLE: F9-P07-T00-DIR-TRUST-KEY
## VARIABLE TYPE: checkbox
## PRODUCTION RULE: NA
V1 <- '//Return/ReturnData/IRS990/CompensationFromOtherSources'
V2 <- '//Return/ReturnData/IRS990/CompensationFromOtherSrcsInd'
V3 <- '//Return/ReturnData/IRS990/Form990PartVIISectionA/CompensationFromOtherSources'
V_COMP_DTK_COMP_OTH_SOURCE_X <- paste( V1, V2, V3 , sep='|' )
F9_07_COMP_DTK_COMP_OTH_SOURCE_X <- xml_text( xml_find_all( doc, V_COMP_DTK_COMP_OTH_SOURCE_X ) )
## VARIABLE NAME: F9_07_COMP_DTK_FORMER_LISTED_X
## DESCRIPTION: Is a former officer, director, or trustee listed in the compensation table in Sectin A Line 1a? (F990-PC-PART-07-SECTION-A: F990-EZ-PART-04-PART-06-LINE-50-CONBINED)
## LOCATION: F990-PC-PART-07-SECTION-A-LINE-03
## TABLE: F9-P07-T00-DIR-TRUST-KEY
## VARIABLE TYPE: checkbox
## PRODUCTION RULE: NA
V1 <- '//Return/ReturnData/IRS990/Form990PartVIISectionA/FormersListedIn1A'
V2 <- '//Return/ReturnData/IRS990/FormerOfcrEmployeesListedInd'
V3 <- '//Return/ReturnData/IRS990/FormersListed'
V_COMP_DTK_FORMER_LISTED_X <- paste( V1, V2, V3 , sep='|' )
F9_07_COMP_DTK_FORMER_LISTED_X <- xml_text( xml_find_all( doc, V_COMP_DTK_FORMER_LISTED_X ) )
## VARIABLE NAME: F9_07_COMP_DTK_COMP_GT_150K_X
## DESCRIPTION: Line1a; total greater than $150K? (F990-PC-PART-07-SECTION-A: F990-EZ-PART-04-PART-06-LINE-50-CONBINED)
## LOCATION: F990-PC-PART-07-SECTION-A-LINE-04
## TABLE: F9-P07-T00-DIR-TRUST-KEY
## VARIABLE TYPE: checkbox
## PRODUCTION RULE: NA
V1 <- '//Return/ReturnData/IRS990/Form990PartVIISectionA/Line1ATotalGT150K'
V2 <- '//Return/ReturnData/IRS990/TotalCompGreaterThan150KInd'
V3 <- '//Return/ReturnData/IRS990/TotalCompGT150K'
V_COMP_DTK_COMP_GT_150K_X <- paste( V1, V2, V3 , sep='|' )
F9_07_COMP_DTK_COMP_GT_150K_X <- xml_text( xml_find_all( doc, V_COMP_DTK_COMP_GT_150K_X ) )
## VARIABLE NAME: F9_07_COMP_DTK_NO_LISTED_X
## DESCRIPTION: No listed persons compensated (F990-PC-PART-07-SECTION-A: F990-EZ-PART-04-PART-06-LINE-50-CONBINED)
## LOCATION: F990-PC-PART-07-SECTION-A-LINE-01A
## TABLE: F9-P07-T00-DIR-TRUST-KEY
## VARIABLE TYPE: checkbox
## PRODUCTION RULE: NA
V1 <- '//Return/ReturnData/IRS990/Form990PartVIISectionA/NoListedPersonsCompensated'
V2 <- '//Return/ReturnData/IRS990/NoListedPersonsCompensated'
V3 <- '//Return/ReturnData/IRS990/NoListedPersonsCompensatedInd'
V_COMP_DTK_NO_LISTED_X <- paste( V1, V2, V3 , sep='|' )
F9_07_COMP_DTK_NO_LISTED_X <- xml_text( xml_find_all( doc, V_COMP_DTK_NO_LISTED_X ) )
## VARIABLE NAME: F9_07_COMP_DTK_NUM_GT_100K
## DESCRIPTION: Number individuals greater than $100K (F990-PC-PART-07-SECTION-A: F990-EZ-PART-04-PART-06-LINE-50-CONBINED)
## LOCATION: F990-PC-PART-07-SECTION-A-LINE-02
## TABLE: F9-P07-T00-DIR-TRUST-KEY
## VARIABLE TYPE: numeric
## PRODUCTION RULE: NA
V1 <- '//Return/ReturnData/IRS990/Form990PartVIISectionA/NumberIndividualsGT100K'
V2 <- '//Return/ReturnData/IRS990/IndivRcvdGreaterThan100KCnt'
V3 <- '//Return/ReturnData/IRS990/NumberIndividualsGT100K'
V_COMP_DTK_NUM_GT_100K <- paste( V1, V2, V3 , sep='|' )
F9_07_COMP_DTK_NUM_GT_100K <- xml_text( xml_find_all( doc, V_COMP_DTK_NUM_GT_100K ) )
## VARIABLE NAME: F9_07_COMP_DTK_COMP_ORG_SUBTOT
## DESCRIPTION: Total; column D (F990-PC-PART-07-SECTION-A: F990-EZ-PART-04-PART-06-LINE-50-CONBINED)
## LOCATION: F990-PC-PART-07-SECTION-A-LINE-01B-COL-D
## TABLE: F9-P07-T00-DIR-TRUST-KEY
## VARIABLE TYPE: numeric
## PRODUCTION RULE: NA
F9_07_COMP_DTK_COMP_ORG_SUBTOT <- xml_text( xml_find_all( doc, '/Return/ReturnData/IRS990/Form990PartVIISectionA/TotalColumnD' ) )
## VARIABLE NAME: F9_07_COMP_DTK_COMP_RLTD_SUBTOT
## DESCRIPTION: Total; column E (F990-PC-PART-07-SECTION-A: F990-EZ-PART-04-PART-06-LINE-50-CONBINED)
## LOCATION: F990-PC-PART-07-SECTION-A-LINE-01B-COL-E
## TABLE: F9-P07-T00-DIR-TRUST-KEY
## VARIABLE TYPE: numeric
## PRODUCTION RULE: NA
F9_07_COMP_DTK_COMP_RLTD_SUBTOT <- xml_text( xml_find_all( doc, '/Return/ReturnData/IRS990/Form990PartVIISectionA/TotalColumnE' ) )
## VARIABLE NAME: F9_07_COMP_DTK_COMP_OTH_SUBTOT
## DESCRIPTION: Total; column F (F990-PC-PART-07-SECTION-A: F990-EZ-PART-04-PART-06-LINE-50-CONBINED)
## LOCATION: F990-PC-PART-07-SECTION-A-LINE-01B-COL-F
## TABLE: F9-P07-T00-DIR-TRUST-KEY
## VARIABLE TYPE: numeric
## PRODUCTION RULE: NA
F9_07_COMP_DTK_COMP_OTH_SUBTOT <- xml_text( xml_find_all( doc, '/Return/ReturnData/IRS990/Form990PartVIISectionA/TotalColumnF' ) )
## VARIABLE NAME: F9_07_INFO_SCHED_O_X
## DESCRIPTION: Schedule O contains a response to a question in Part VII
## LOCATION: F990-PC-PART-07-LINE-00
## TABLE: F9-P07-T00-DIR-TRUST-KEY
## VARIABLE TYPE: checkbox
## PRODUCTION RULE: NA
V1 <- '//Return/ReturnData/IRS990/InfoInScheduleOPartVII'
V2 <- '//Return/ReturnData/IRS990/InfoInScheduleOPartVIIInd'
V3 <- '//Return/ReturnData/IRS990EZ/InfoInScheduleOPartIV'
V4 <- '//Return/ReturnData/IRS990EZ/InfoInScheduleOPartIVInd'
V5 <- '//Return/ReturnData/IRS990EZ/InfoInScheduleOPartVII'
V6 <- '//Return/ReturnData/IRS990EZ/InfoInScheduleOPartVIIInd'
V_INFO_SCHED_O_X <- paste( V1, V2, V3, V4, V5, V6 , sep='|' )
F9_07_INFO_SCHED_O_X <- xml_text( xml_find_all( doc, V_INFO_SCHED_O_X ) )
## VARIABLE NAME: F9_07_COMP_DTK_COMP_OTH_TOT
## DESCRIPTION: Total, column F (F990-PC-PART-07-SECTION-A: F990-EZ-PART-04-PART-06-LINE-50-CONBINED)
## LOCATION: F990-PC-PART-07-SECTION-A-LINE-01D-COL-F
## TABLE: F9-P07-T00-DIR-TRUST-KEY
## VARIABLE TYPE: numeric
## PRODUCTION RULE: NA
V1 <- '//Return/ReturnData/IRS990/TotalOtherCompensation'
V2 <- '//Return/ReturnData/IRS990/TotalOtherCompensationAmt'
V_COMP_DTK_COMP_OTH_TOT <- paste( V1, V2 , sep='|' )
F9_07_COMP_DTK_COMP_OTH_TOT <- xml_text( xml_find_all( doc, V_COMP_DTK_COMP_OTH_TOT ) )
## VARIABLE NAME: F9_07_COMP_DTK_COMP_RLTD_TOT
## DESCRIPTION: Total, column E (F990-PC-PART-07-SECTION-A: F990-EZ-PART-04-PART-06-LINE-50-CONBINED)
## LOCATION: F990-PC-PART-07-SECTION-A-LINE-01D-COL-E
## TABLE: F9-P07-T00-DIR-TRUST-KEY
## VARIABLE TYPE: numeric
## PRODUCTION RULE: NA
V1 <- '//Return/ReturnData/IRS990/TotalReportableCompFrmRltdOrgs'
V2 <- '//Return/ReturnData/IRS990/TotReportableCompRltdOrgAmt'
V_COMP_DTK_COMP_RLTD_TOT <- paste( V1, V2 , sep='|' )
F9_07_COMP_DTK_COMP_RLTD_TOT <- xml_text( xml_find_all( doc, V_COMP_DTK_COMP_RLTD_TOT ) )
## VARIABLE NAME: F9_07_COMP_DTK_COMP_ORG_TOT
## DESCRIPTION: Total, column D (F990-PC-PART-07-SECTION-A: F990-EZ-PART-04-PART-06-LINE-50-CONBINED)
## LOCATION: F990-PC-PART-07-SECTION-A-LINE-01D-COL-D
## TABLE: F9-P07-T00-DIR-TRUST-KEY
## VARIABLE TYPE: numeric
## PRODUCTION RULE: NA
V1 <- '//Return/ReturnData/IRS990/TotalReportableCompFromOrg'
V2 <- '//Return/ReturnData/IRS990/TotalReportableCompFromOrgAmt'
V_COMP_DTK_COMP_ORG_TOT <- paste( V1, V2 , sep='|' )
F9_07_COMP_DTK_COMP_ORG_TOT <- xml_text( xml_find_all( doc, V_COMP_DTK_COMP_ORG_TOT ) )
## VARIABLE NAME: F9_07_SCHED_A_FILED_X
## DESCRIPTION: Did the organization complete Schedule A?
## LOCATION: F990-EZ-PART-06-LINE-52
## TABLE: F9-P07-T00-DIR-TRUST-KEY
## VARIABLE TYPE: checkbox
## PRODUCTION RULE: NA
V1 <- '//Return/ReturnData/IRS990EZ/FiledScheduleA'
V2 <- '//Return/ReturnData/IRS990EZ/FiledScheduleAInd'
V_SCHED_A_FILED_X <- paste( V1, V2 , sep='|' )
F9_07_SCHED_A_FILED_X <- xml_text( xml_find_all( doc, V_SCHED_A_FILED_X ) )
## VARIABLE NAME: F9_07_COMP_DTK_NUM_GT_100K_HCE
## DESCRIPTION: Total number of other employees paid over $100;000 (F990-PC-PART-07-SECTION-A: F990-EZ-PART-04-PART-06-LINE-50-CONBINED)
## LOCATION: F990-EZ-PART-06-LINE-50F
## TABLE: F9-P07-T00-DIR-TRUST-KEY
## VARIABLE TYPE: numeric
## PRODUCTION RULE: NA
V1 <- '//Return/ReturnData/IRS990EZ/OtherEmployeePaidOver100kCnt'
V2 <- '//Return/ReturnData/IRS990EZ/TotNumberOfOthEmplPaidOver100k'
V_COMP_DTK_NUM_GT_100K_HCE <- paste( V1, V2 , sep='|' )
F9_07_COMP_DTK_NUM_GT_100K_HCE <- xml_text( xml_find_all( doc, V_COMP_DTK_NUM_GT_100K_HCE ) )
var.list <-
namedList(OBJECTID,URL,ORG_EIN,ORG_NAME_L1,ORG_NAME_L2,RETURN_TYPE,TAX_YEAR,F9_07_COMP_KONTR_NUM_GT_100K,F9_07_COMP_DTK_COMP_OTH_SOURCE_X,F9_07_COMP_DTK_FORMER_LISTED_X,F9_07_COMP_DTK_COMP_GT_150K_X,F9_07_COMP_DTK_NO_LISTED_X,F9_07_COMP_DTK_NUM_GT_100K,F9_07_COMP_DTK_COMP_ORG_SUBTOT,F9_07_COMP_DTK_COMP_RLTD_SUBTOT,F9_07_COMP_DTK_COMP_OTH_SUBTOT,F9_07_INFO_SCHED_O_X,F9_07_COMP_DTK_COMP_OTH_TOT,F9_07_COMP_DTK_COMP_RLTD_TOT,F9_07_COMP_DTK_COMP_ORG_TOT,F9_07_SCHED_A_FILED_X,F9_07_COMP_DTK_NUM_GT_100K_HCE)
df <- as.data.frame( var.list )
return( df )
}
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.