API tools faq
paste
Advertisement
anonymousleyte

PDAF Database Informations

anonymousleyte
Aug 30th, 2013
1,085
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.61 KB | None | 0 0
raw download clone embed print report
  1. They say it will take 12 years in prison for leaking a database!
  2. Unless you will be a state witness, you will be taken special treatment by the government!
  3. Gonna try if it's true!
  4. =============================================================================
  5.  
  6. Website Name: http://pdaf.dbm.gov.ph
  7. Status: Leaked
  8. Reason: Protest to abolish Pork Barrel/PDAF
  9.  
  10. ==============================================================================
  11.  
  12. Total Number of Corruption: Unlimited
  13.  
  14. -------------------------------------------------------------------------------
  15.  
  16. Total Number of Tables: 41
  17.  
  18. --------------------------------------------------------------------------------
  19.  
  20. Total Number of Columns: 872
  21.  
  22. --------------------------------------------------------------------------------
  23.  
  24. Database Name: tails
  25.  
  26. ================================================================================
  27. Extracted Database
  28. [without the data]
  29.  
  30. Tables: Columns:
  31.  
  32. APPRO_CODE Src_cd
  33. Src_dsc
  34.  
  35. SYS_PARAM Fiscal_Year
  36. DPWH_PostDate
  37. PDAF_PostDate
  38. IRA_PostDate
  39. FSLGU_PostDate
  40. SBP_PostDate
  41.  
  42. LEGAL_BASIS Budg_Yr
  43. Legal_Dsc
  44. Src_Cd
  45. Legal_Cd
  46.  
  47. PROVINCE PRO_CD
  48. REG_CD
  49. REG_DSC
  50. PRO_DSC
  51.  
  52. LEGISLATOR LEGIST_CD
  53. GENDER
  54. DIST_CD
  55. TERM_END
  56. TERM_START
  57. LAST_NAME
  58. LEGIST_TYPE
  59. MIDDLE_NAME
  60. ACTV_TAG
  61. FIRST_NAME
  62.  
  63. REGION REG_CD
  64. REG_DSC
  65.  
  66. MUNICITY MUN_CD
  67. MUN_DSC
  68. PRO_CD
  69. REG_CD
  70. OWNER_TYPE_CD
  71. ACTIVE_TAG
  72. DIST_CD
  73.  
  74. FOOTNOTES FN_CD
  75. FN_DESC
  76.  
  77. TBLIRA Region
  78. Province
  79. MuniCity
  80. January
  81. March
  82. Population
  83. February
  84. MuniCityType
  85. June
  86. LGULevel
  87. May
  88. July
  89. LandArea
  90. August
  91. Barangay
  92. April
  93. November
  94. Total
  95. October
  96. December
  97. September
  98. FiscalYear
  99.  
  100. TBLIRAPARAM FiscalYear
  101. CensusYear
  102. Oth_Remarks
  103. IRAAmount
  104. LA_Remarks
  105. Pop_Remarks
  106.  
  107. TBLIRAPARMS RegionID
  108. MuniCityID
  109. BarangayName
  110. LGULevel
  111. ProvinceID
  112. BarangayID
  113. ProvinceName
  114. MuniCityType
  115. RegionSortOrder
  116. GuaranteedShare
  117. EqualShare
  118. LandArea
  119. BarangayWith100AndMore
  120. Population
  121. FiscalYear
  122. MuniCityName
  123. Status
  124. PopulationShare
  125. PostMonth
  126. GrpSort
  127. RegionName
  128. LandAreaShare
  129. CityZone
  130.  
  131. LEGIST_WFN ID
  132. LEGISLATORTYPE
  133. REGIONID
  134. LEGISLATORID
  135. LEGISLATORNAME
  136. FN_CD
  137. FISCALYEAR
  138. FUNDTYPE
  139.  
  140. TBLIRASHARE RegionID
  141. ProvinceName
  142. MuniCityType
  143. MuniCityID
  144. ProvinceID
  145. Population
  146. LandArea
  147. GuaranteedShare
  148. LGULevel
  149. PopulationShare
  150. RegionName
  151. RegionSortOrder
  152. BarangayID
  153. BarangayName
  154. LandAreaShare
  155. EqualShare
  156. January
  157. BarangayWith100AndMore
  158. February
  159. March
  160. April
  161. May
  162. June
  163. MuniCityName
  164. July
  165. August
  166. September
  167. October
  168. November
  169. December
  170. Total
  171. FiscalYear
  172. Status
  173. PostMonth
  174. CityZone
  175. GrpSort
  176. PrimarySortID
  177.  
  178. TBLIRASHARE_20120814 RegionID
  179. RegionName
  180. RegionSortOrder
  181. ProvinceID
  182. ProvinceName
  183. MuniCityID
  184. MuniCityName
  185. BarangayID
  186. MuniCityType
  187. BarangayName
  188. LGULevel
  189. Population
  190. LandArea
  191. GuaranteedShare
  192. PopulationShare
  193. LandAreaShare
  194. EqualShare
  195. BarangayWith100AndMore
  196. January
  197. February
  198. March
  199. April
  200. May
  201. June
  202. July
  203. August
  204. September
  205. October
  206. November
  207. December
  208. Total
  209. Status
  210. CityZone
  211. PostMonth
  212. FiscalYear
  213. PrimarySortID
  214. GrpSort
  215.  
  216. TBLIRASHARE_20130130 RegionID
  217. RegionName
  218. RegionSortOrder
  219. ProvinceID
  220. ProvinceName
  221. MuniCityID
  222. MuniCityName
  223. MuniCityType
  224. BarangayName
  225. BarangayID
  226. LGULevel
  227. Population
  228. LandArea
  229. LandAreaShare
  230. GuaranteedShare
  231. EqualShare
  232. March
  233. BarangayWith100AndMore
  234. April
  235. February
  236. May
  237. June
  238. July
  239. August
  240. PopulationShare
  241. September
  242. October
  243. January
  244. November
  245. December
  246. Total
  247. FiscalYear
  248. Status
  249. PostMonth
  250. CityZone
  251. GrpSort
  252. PrimarySortID
  253.  
  254. TBLIRASHARE_BACKUP RegionID
  255. RegionName
  256. RegionSortOrder
  257. ProvinceID
  258. ProvinceName
  259. MuniCityID
  260. MuniCityName
  261. MuniCityType
  262. BarangayName
  263. BarangayID
  264. LGULevel
  265. Population
  266. LandArea
  267. LandAreaShare
  268. GuaranteedShare
  269. EqualShare
  270. March
  271. BarangayWith100AndMore
  272. April
  273. February
  274. May
  275. June
  276. July
  277. August
  278. PopulationShare
  279. September
  280. October
  281. January
  282. November
  283. December
  284. Total
  285. FiscalYear
  286. Status
  287. PostMonth
  288. CityZone
  289. GrpSort
  290. PrimarySortID
  291.  
  292. TBLPDAFDPWH_20120713 ID
  293. LegislatorID
  294. RegionID
  295. DistrictID
  296. DistrictName
  297. LegislatorType
  298. LegislatorName
  299. ProvinceID
  300. DocID
  301. ProvinceName
  302. Recipient
  303. Project2
  304. Amount
  305. ImplementingUnit
  306. FiscalYear
  307. Legal_Cd
  308. Src_Cd
  309. RegionName
  310. Alt_Legist
  311. FundType
  312. MunicityName
  313. SpclRel
  314. Issue_Date
  315. Legist_RegionID
  316. Legist_RegionName
  317. MunicityID
  318. Legist_ProvinceID
  319. Legist_ProvinceName
  320. Program
  321. Project
  322. Legist_DistrictID
  323. Legist_DistrictName
  324. Legist_MunicityID
  325. Legist_MunicityName
  326.  
  327. TBLPDAFDPWH_201300314 ID
  328. LegislatorID
  329. RegionID
  330. DistrictID
  331. DistrictName
  332. LegislatorType
  333. LegislatorName
  334. ProvinceID
  335. DocID
  336. ProvinceName
  337. Recipient
  338. Project2
  339. Amount
  340. ImplementingUnit
  341. FiscalYear
  342. Legal_Cd
  343. Src_Cd
  344. RegionName
  345. Alt_Legist
  346. FundType
  347. MunicityName
  348. SpclRel
  349. Issue_Date
  350. Legist_RegionID
  351. Legist_RegionName
  352. MunicityID
  353. Legist_ProvinceID
  354. Legist_ProvinceName
  355. Program
  356. Project
  357. Legist_DistrictID
  358. Legist_DistrictName
  359. Legist_MunicityID
  360. Legist_MunicityName
  361.  
  362. TBLPDAF LegislatorName
  363. Program
  364. Project
  365. Province
  366. Amount
  367. ImplementingUnit
  368. FiscalYear
  369. Region
  370. District
  371. Id
  372. AmountText
  373. FundType
  374. LegislatorType
  375. LegislatorID
  376. Location
  377.  
  378. TBLPDAFDPWH_20130214 ID
  379. LegislatorID
  380. RegionID
  381. DistrictID
  382. DistrictName
  383. LegislatorType
  384. LegislatorName
  385. ProvinceID
  386. DocID
  387. ProvinceName
  388. Recipient
  389. Project2
  390. Amount
  391. ImplementingUnit
  392. FiscalYear
  393. Legal_Cd
  394. Src_Cd
  395. RegionName
  396. Alt_Legist
  397. FundType
  398. MunicityName
  399. SpclRel
  400. Issue_Date
  401. Legist_RegionID
  402. Legist_RegionName
  403. MunicityID
  404. Legist_ProvinceID
  405. Legist_ProvinceName
  406. Program
  407. Project
  408. Legist_DistrictID
  409. Legist_DistrictName
  410. Legist_MunicityID
  411. Legist_MunicityName
  412.  
  413. TBLPDAFDPWH_20130802 ID
  414. LegislatorID
  415. RegionID
  416. DistrictID
  417. DistrictName
  418. LegislatorType
  419. LegislatorName
  420. ProvinceID
  421. DocID
  422. ProvinceName
  423. Recipient
  424. Project2
  425. Amount
  426. ImplementingUnit
  427. FiscalYear
  428. Legal_Cd
  429. Src_Cd
  430. RegionName
  431. Alt_Legist
  432. FundType
  433. MunicityName
  434. SpclRel
  435. Issue_Date
  436. Legist_RegionID
  437. Legist_RegionName
  438. MunicityID
  439. Legist_ProvinceID
  440. Legist_ProvinceName
  441. Program
  442. Project
  443. Legist_DistrictID
  444. Legist_DistrictName
  445. Legist_MunicityID
  446. Legist_MunicityName
  447.  
  448. DISTRICT DIST_CD
  449. REG_CD
  450. PRO_CD
  451. DIST_DSC
  452. PRO_DSC
  453. MUN_CD
  454. REG_DSC
  455.  
  456. LEGIST_WOUT_REL ID
  457. LegislatorID
  458. RegionID
  459. DistrictID
  460. DistrictName
  461. LegislatorType
  462. LegislatorName
  463. ProvinceID
  464. DocID
  465. ProvinceName
  466. Recipient
  467. Project2
  468. Amount
  469. ImplementingUnit
  470. FiscalYear
  471. Legal_Cd
  472. Src_Cd
  473. RegionName
  474. Alt_Legist
  475. FundType
  476. MunicityName
  477. SpclRel
  478. Issue_Date
  479. Legist_RegionID
  480. Legist_RegionName
  481. MunicityID
  482. Legist_ProvinceID
  483. Legist_ProvinceName
  484. Program
  485. Project
  486. Legist_DistrictID
  487. Legist_DistrictName
  488. Legist_MunicityID
  489. Legist_MunicityName
  490.  
  491. TBLPDAFDPWH_TEST ID
  492. LegislatorID
  493. RegionID
  494. DistrictID
  495. DistrictName
  496. LegislatorType
  497. LegislatorName
  498. ProvinceID
  499. DocID
  500. ProvinceName
  501. Recipient
  502. Project2
  503. Amount
  504. ImplementingUnit
  505. FiscalYear
  506. Legal_Cd
  507. Src_Cd
  508. RegionName
  509. Alt_Legist
  510. FundType
  511. MunicityName
  512. SpclRel
  513. Issue_Date
  514. Legist_RegionID
  515. Legist_RegionName
  516. MunicityID
  517. Legist_ProvinceID
  518. Legist_ProvinceName
  519. Program
  520. Project
  521. Legist_DistrictID
  522. Legist_DistrictName
  523. Legist_MunicityID
  524. Legist_MunicityName
  525.  
  526. TBLPDAFDPWH ID
  527. LegislatorID
  528. RegionID
  529. DistrictID
  530. DistrictName
  531. LegislatorType
  532. LegislatorName
  533. ProvinceID
  534. DocID
  535. ProvinceName
  536. Recipient
  537. Project2
  538. Amount
  539. ImplementingUnit
  540. FiscalYear
  541. Legal_Cd
  542. Src_Cd
  543. RegionName
  544. Alt_Legist
  545. FundType
  546. MunicityName
  547. SpclRel
  548. Issue_Date
  549. Legist_RegionID
  550. Legist_RegionName
  551. MunicityID
  552. Legist_ProvinceID
  553. Legist_ProvinceName
  554. Program
  555. Project
  556. Legist_DistrictID
  557. Legist_DistrictName
  558. Legist_MunicityID
  559. Legist_MunicityName
  560.  
  561. TBLPDAFDPWH_BACKUP ID
  562. LegislatorID
  563. RegionID
  564. DistrictID
  565. DistrictName
  566. LegislatorType
  567. LegislatorName
  568. ProvinceID
  569. DocID
  570. ProvinceName
  571. Recipient
  572. Project2
  573. Amount
  574. ImplementingUnit
  575. FiscalYear
  576. Legal_Cd
  577. Src_Cd
  578. RegionName
  579. Alt_Legist
  580. FundType
  581. MunicityName
  582. SpclRel
  583. Issue_Date
  584. Legist_RegionID
  585. Legist_RegionName
  586. MunicityID
  587. Legist_ProvinceID
  588. Legist_ProvinceName
  589. Program
  590. Project
  591. Legist_DistrictID
  592. Legist_DistrictName
  593. Legist_MunicityID
  594. Legist_MunicityName
  595.  
  596. TBLPROJDTL SARO_ID
  597. PROJ_ID
  598. PROJ_DSC
  599. LIST_LEVEL
  600. IS_HEADER
  601.  
  602. TBLPDAFDPWH_BAK ID
  603. DocID
  604. LegislatorName
  605. LegislatorID
  606. LegislatorType
  607. RegionID
  608. RegionName
  609. ProvinceID
  610. ProvinceName
  611. DistrictID
  612. DistrictName
  613. Program
  614. Project
  615. Project2
  616. Recipient
  617. Amount
  618. FiscalYear
  619. ImplementingUnit
  620. FundType
  621. Legal_Cd
  622. Src_Cd
  623. Issue_Date
  624. Alt_Legist
  625. MunicityID
  626. MunicityName
  627. SpclRel
  628.  
  629. TBLPDAFDPWH_20120719 ID
  630. ProvinceName
  631. ProvinceID
  632. LegislatorID
  633. LegislatorName
  634. Program
  635. DistrictID
  636. DocID
  637. Project
  638. ImplementingUnit
  639. Project2
  640. DistrictName
  641. FiscalYear
  642. LegislatorType
  643. RegionName
  644. Src_Cd
  645. RegionID
  646. Issue_Date
  647. Legal_Cd
  648. Alt_Legist
  649. Amount
  650. Legist_RegionID
  651. Legist_RegionName
  652. SpclRel
  653. Recipient
  654. Legist_DistrictID
  655. MunicityName
  656. FundType
  657. Legist_MunicityName
  658. MunicityID
  659. Legist_DistrictName
  660. Legist_ProvinceName
  661. Legist_MunicityID
  662.  
  663. V_Continuing ID
  664. LegislatorType
  665. RegionName
  666. ProvinceName
  667. RegionID
  668. Program
  669. Project2
  670. Recipient
  671. LegislatorName
  672. DistrictID
  673. DistrictName
  674. ImplementingUnit
  675. Legal_Cd
  676. Amount
  677. Project
  678. FiscalYear
  679. MunicityID
  680. Alt_Legist
  681. MunicityName
  682. FundType
  683. Src_Cd
  684. Legist_RegionID
  685. DocID
  686. Legist_ProvinceName
  687. Legist_DistrictName
  688. SpclRel
  689. Legist_MunicityID
  690. Legist_RegionName
  691. ProvinceID
  692. Legist_MunicityName
  693. Legist_DistrictID
  694. Continuing
  695. LegislatorID
  696. Issue_Date
  697. Legist_ProvinceID
  698.  
  699. V_New_Appro ID
  700. ProvinceName
  701. ProvinceID
  702. LegislatorID
  703. LegislatorName
  704. Program
  705. DistrictID
  706. DocID
  707. Project
  708. ImplementingUnit
  709. Project2
  710. DistrictName
  711. FiscalYear
  712. LegislatorType
  713. RegionName
  714. Src_Cd
  715. RegionID
  716. Issue_Date
  717. Legal_Cd
  718. Alt_Legist
  719. Amount
  720. Legist_RegionID
  721. Legist_RegionName
  722. SpclRel
  723. Recipient
  724. Legist_DistrictID
  725. MunicityName
  726. FundType
  727. Legist_MunicityName
  728. MunicityID
  729. Legist_DistrictName
  730. Legist_ProvinceName
  731. Legist_MunicityID
  732.  
  733. pbcatcol pbc_tnam
  734. pbc_tid
  735. pbc_ownr
  736. pbc_cid
  737. pbc_lpos
  738. pbc_hpos
  739. pbc_mask
  740. pbc_hdr
  741. pbc_labl
  742. pbc_cnam
  743. pbc_jtfy
  744. pbc_hght
  745. pbc_bmap
  746. pbc_edit
  747. pbc_tag
  748. pbc_wdth
  749. pbc_init
  750. pbc_cmnt
  751. pbc_ptrn
  752. pbc_case
  753.  
  754. pbcatedt pbe_name
  755. pbe_edit
  756. pbe_cntr
  757. pbe_flag
  758. pbe_seqn
  759. pbe_type
  760. pbe_work
  761.  
  762. pbcatfmt pbf_name
  763. pbf_frmt
  764. pbf_cntr
  765. pbf_type
  766.  
  767. TBLPDFADPWH_20130824 ID
  768. LegislatorID
  769. RegionID
  770. DistrictID
  771. DistrictName
  772. LegislatorType
  773. LegislatorName
  774. ProvinceID
  775. DocID
  776. ProvinceName
  777. Recipient
  778. Project2
  779. Amount
  780. ImplementingUnit
  781. FiscalYear
  782. Legal_Cd
  783. Src_Cd
  784. RegionName
  785. Alt_Legist
  786. FundType
  787. MunicityName
  788. SpclRel
  789. Issue_Date
  790. Legist_RegionID
  791. Legist_RegionName
  792. MunicityID
  793. Legist_ProvinceID
  794. Legist_ProvinceName
  795. Program
  796. Project
  797. Legist_DistrictID
  798. Legist_DistrictName
  799. Legist_MunicityID
  800. Legist_MunicityName
  801.  
  802. TBLPDAFDPWH_20121107 ID
  803. LegislatorID
  804. RegionID
  805. DistrictID
  806. DistrictName
  807. LegislatorType
  808. LegislatorName
  809. ProvinceID
  810. DocID
  811. ProvinceName
  812. Recipient
  813. Project2
  814. Amount
  815. ImplementingUnit
  816. FiscalYear
  817. Legal_Cd
  818. Src_Cd
  819. RegionName
  820. Alt_Legist
  821. FundType
  822. MunicityName
  823. SpclRel
  824. Issue_Date
  825. Legist_RegionID
  826. Legist_RegionName
  827. MunicityID
  828. Legist_ProvinceID
  829. Legist_ProvinceName
  830. Program
  831. Project
  832. Legist_DistrictID
  833. Legist_DistrictName
  834. Legist_MunicityID
  835. Legist_MunicityName
  836.  
  837. TBLSBP SchoolName
  838. Units
  839. ConstructionType
  840. Province
  841. Amount
  842. Remarks
  843. Region
  844. SS_sites
  845. Location
  846. Legislator
  847. FiscalYear
  848. ES_sites
  849. BuildingType
  850. Repair_Target
  851. New_Target
  852. SchoolType
  853. Legal_Cd
  854. Room_size
  855. Src_Cd
  856. Toilet_Target
  857. District
  858. Id
  859. Upload_Datetime
  860. Division
  861. Reference
  862.  
  863. pbcattbl pbt_tnam
  864. pbt_ownr
  865. pbd_ffce
  866. pbt_tid
  867. pbh_fwgt
  868. pbh_fhgt
  869. pbd_fitl
  870. pbh_fitl
  871. pbd_fchr
  872. pbh_fptc
  873. pbh_funl
  874. pbd_funl
  875. pbh_ffce
  876. pbh_fchr
  877. pbd_fwgt
  878. pbl_fwgt
  879. pbl_fitl
  880. pbd_fhgt
  881. pbl_fchr
  882. pbl_fptc
  883. pbl_ffce
  884. pbt_cmnt
  885. pbd_fptc
  886. pbl_fhgt
  887. pbl_funl
  888.  
  889. pbcatvld pbv_name
  890. pbv_cntr
  891. pbv_msg
  892. pbv_vald
  893. pbv_type
  894.  
  895. TLBPDAFDPWH ID
  896. LegislatorID
  897. RegionID
  898. DistrictID
  899. DistrictName
  900. LegislatorType
  901. LegislatorName
  902. ProvinceID
  903. DocID
  904. ProvinceName
  905. Recipient
  906. Project2
  907. Amount
  908. ImplementingUnit
  909. FiscalYear
  910. Legal_Cd
  911. Src_Cd
  912. RegionName
  913. Alt_Legist
  914. FundType
  915. MunicityName
  916. SpclRel
  917. Issue_Date
  918. Legist_RegionID
  919. Legist_RegionName
  920. MunicityID
  921. Legist_ProvinceID
  922. Legist_ProvinceName
  923. Program
  924. Project
  925. Legist_DistrictID
  926. Legist_DistrictName
  927. Legist_MunicityID
  928. Legist_MunicityName
  929.  
  930. TBSBP SchoolName
  931. Province
  932. BuildingType
  933. ConstructionType
  934. FiscalYear
  935. Region
  936. SchoolType
  937. Location
  938. Legislator
  939. Remarks
  940. Amount
  941. District
  942. Units
  943.  
  944. ============================================================================
  945.  
  946. via Anonymous Philippines
  947.  
  948. Salutes to:
  949. #PinoyVendetta
  950. #StrawhatPirates
  951. #PhilippineCyberArmy
  952. #ShadowHaxor
  953. #MagdaloCyberArmy
  954. #PhantomHackersPH
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!