API tools faq
paste
Advertisement
tokala

Pakistan Federal Public Service database

tokala
Aug 4th, 2011
536
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.92 KB | None | 0 0
raw download clone embed print report
  1. tokalanz@gmail.com
  2.  
  3.  
  4. FPSC.GOV.PK
  5.  
  6. Pakistan Government Federal Public Service Commission
  7.  
  8. Oracle 10g Database
  9.  
  10.  
  11. ADMIN TABLE
  12.  
  13. ADMIN_ID ADMIN_FIRST_NAME ADMIN_LAST_NAME GR_EMPLOYER_LOGIN GR_EMPLOYER_PASSWORD
  14.  
  15. 1 WM FPSC admin 0b1a7954d6188645b5206a1ac838bc4099ff9c8d
  16. 663 MASGHAR cb03497fc1a7902d9f2f1f80f2eeaba9fcafc439
  17. 643 AIQBAL a5164b0c9b674c303d2c402a942b2f0d421ba2f0
  18. 623 RWAHEED 123456
  19.  
  20.  
  21.  
  22.  
  23. EIS_EMPLOYEE_NAME EIS_DATE_OF_BIRTH EIS_WORK_DATE EIS_FATHER_NAME EIS_RELIGION EIS_GENDER EIS_BLOOD_GROUP EIS_ID_MARK EIS_MARITAL_STATUS
  24.  
  25. I also have the employee table but decided I wouldn't post it, not into posting people's personal details.
  26.  
  27.  
  28. Database Table Layout
  29.  
  30. USER_LOG (Table)
  31. ID
  32. USER_LOGIN_ID
  33. USER_LOG_DATE
  34. USER_LOG_TIME
  35. USER_LOG_URL
  36. USER_LOG_TABLE
  37. USER_LOG_OUT_TIME
  38. USER_LOG_IN_TIME
  39. USER_ACTION
  40. USER_IP
  41. RECORD_ID
  42.  
  43.  
  44. ADMIN (Table)
  45. ADMIN_ID
  46. ADMIN_FIRST_NAME
  47. ADMIN_LAST_NAME
  48. GR_EMPLOYER_LOGIN
  49. GR_EMPLOYER_PASSWORD
  50. GR_EMPLOYER_EMAIL
  51. GR_EMP_ID
  52. ADMIN_STATUS
  53.  
  54.  
  55. CENTER (Table)
  56. CENTER_ID
  57. CENTER_NAME
  58. CENTER_CODE
  59. INTERVIEW_CENTER
  60. GR_CENTER
  61.  
  62.  
  63. CENTER_SUB (Table)
  64. SUB_CENTER_ID
  65. SUB_CENTER_NAME
  66. CENTER_ID
  67. SUB_CENTER_ADD
  68. CSS_ADVERTISEMENT_ID
  69.  
  70.  
  71.  
  72. EIS_ADDRESS_INFORMATION (Table)
  73. EIS_MOBILE_PHONE
  74. EIS_EMAIL_ADDRESS
  75. EIS_EMP_EMERGENCY_ADDRESS
  76. EIS_EMP_EMERGENCY_PHONE
  77.  
  78.  
  79. EIS_BOARD (Table)
  80. EIS_BOARD_ID
  81. EIS_BOARD_NAME
  82. EIS_CITY
  83. EIS_CHILDREN_INFO_ID
  84.  
  85.  
  86. EIS_CHILDREN_INFORMATION (Table)
  87. EIS_EMPLOYEE_CODE
  88. EIS_CHILD_NAME
  89. EIS_GENDER
  90. EIS_DATE_OF_BIRTH
  91.  
  92.  
  93. EIS_COUNTRY (Table)
  94. EIS_COUNTRY_ID
  95. EIS_NAME
  96.  
  97.  
  98. EIS_COURSES (Table)
  99. EIS_COURSE_ID
  100. EIS_COURSE_NAME
  101.  
  102.  
  103. EIS_DEGREE (Table)
  104. EIS_DEGREE_ID
  105. EIS_NAME
  106.  
  107.  
  108. EIS_DEPUTATION_INFORMATION (Table)
  109. EIS_DEPUTATION_ID
  110. EIS_EMPLOYEE_CODE
  111. EIS_FROM_DATE
  112. EIS_TO_DATE
  113. EIS_ORGANIZATION
  114.  
  115.  
  116. EIS_DESIGNATION (Table)
  117. EIS_DESIGNATION_ID
  118. EIS_DESCRIPTION
  119.  
  120.  
  121. EIS_DISTRICT (Table)
  122. EIS_DISTRICT_ID
  123. EIS_NAME
  124.  
  125.  
  126. EIS_DOMICILE (Table)
  127. EIS_DOMICILE_ID
  128. EIS_NAME
  129. EIS_TYPE
  130.  
  131.  
  132. EIS_EMPLOYEE_LANGUAGE (Table)
  133. EIS_EMP_LANGUAGE_ID
  134. EIS_LANGUAGE_ID
  135. EIS_EMPLOYEE_CODE
  136. EIS_READ
  137. EIS_WRITE
  138. EIS_SPEAK
  139. EIS_CERTIFICATION_DIPLOMA
  140.  
  141.  
  142. EIS_EMPLOYEE_QUALIFICATION (Table)
  143. EIS_EMP_QAUL_ID
  144. EIS_EMPLOYEE_CODE
  145. EIS_COUNTRY_ID
  146. EIS_BOARD_ID
  147. EIS_PASSING_DATE
  148. EIS_MAJOR_SUBJECTS
  149. EIS_UNIVERSITY_ID
  150. EIS_DEGREE_ID
  151.  
  152.  
  153. EIS_EMP_ACR (Table)
  154. EIS_EMP_ACR_ID
  155. EIS_EMPLOYEE_CODE
  156. ACR_DATE
  157. ACR_FROM
  158. ACR_TO
  159. INTEGRITY
  160. PEN_PICTURE
  161. SPECIAL_APTITUDE
  162. RECOMONDATION
  163. REPORTING_OFFICER_ID
  164. OVER_ALL_GRD_RPT
  165. FITNESS_PROMOTION_RPT
  166. RPT_OFFICER_DATE
  167. COUNTER_OFFICER_ID
  168. OVER_ALL_GRD_COUNT
  169. FITNESS_PROMOTION_COUNT
  170. REMARKS_COUNT_OFFICER
  171. EVALUATION_RPT_OFFICER
  172. COUNT_OFFICER_DATE
  173.  
  174.  
  175. EIS_EMP_ADDITIONAL_CHARGE (Table)
  176. EIS_ADDITIONAL_CHARGE_ID
  177. EIS_EMPLOYEE_CODE
  178. EIS_FROM_DATE
  179. EIS_TO_DATE
  180. EIS_ADDITIONAL_CHARGE
  181.  
  182.  
  183. EIS_EMP_ASSETS_ATTORNEY (Table)
  184. EIS_ASSETS_ATTORNEY_ID
  185. EIS_EMPLOYEE_CODE
  186. IDENTIFICATION_AND_NATURE
  187. NATURE_OF_ATTORNEY
  188. NAME_ADDRESS_REAL_OWNER
  189. DECLARATION_DATE
  190.  
  191.  
  192. EIS_EMP_BANK_ACCOUNTS (Table)
  193. EIS_BANK_ACCOUNT_ID
  194. EIS_EMPLOYEE_CODE
  195. AC_NUMBER_BANK_BRANCH
  196. YEAR_OF_OPENING
  197. MAIN_SOURCE_DESPOSIT
  198. BANK_BALANCE
  199. DECLARATION_DATE
  200.  
  201.  
  202. EIS_EMP_CURRENT_CHARGE (Table)
  203. EIS_CURRENT_CHARGE_ID
  204. EIS_EMPLOYEE_CODE
  205. EIS_FROM_DATE
  206. EIS_TO_DATE
  207. EIS_CURRENT_CHARGE
  208.  
  209.  
  210. EIS_EMP_DEPENDENTS (Table)
  211. EIS_EMP_DEPENDENTS_ID
  212. EIS_EMP_EMPLOYEE_CODE
  213. EIS_EMP_DEPENDENT_NAME
  214. EIS_EMP_RELATION
  215. EIS_EMP_DOB
  216. EIS_EMP_GENDER
  217. EIS_EMP_STATUS
  218.  
  219.  
  220. EIS_EMP_DISCIPLINARY_ACTION (Table)
  221. EIS_DISCIPLINARY_ID
  222. EIS_EMPLOYEE_CODE
  223. COMMITTED_ACTION
  224. BRIEF_PENALITIES
  225. PENATLY_REWARDED
  226. ACTION_DATE
  227.  
  228.  
  229. EIS_EMP_HIRING (Table)
  230. EIS_HIRING_ID
  231. EIS_EMPLOYEE_CODE
  232. ACCOMODATION_TYPE
  233. HIRING_DATE
  234. EIS_HIRING_ADDRESS
  235.  
  236.  
  237. EIS_EMP_HONORARIUM (Table)
  238. EIS_HONORARIUM
  239. EIS_EMPLOYEE_CODE
  240. HONORARIUM_YEAR
  241. HONORARIUM_AMOUNT
  242. HONORARIUM_REMARKS
  243.  
  244.  
  245. EIS_EMP_IM_MOVEABLE_ASSETS (Table)
  246. IMMOVEABLE_ID
  247. EIS_EMPLOYEE_CODE
  248. IDENTIFICATION_AND_NATURE
  249. MODE_OF_ACQUISITION
  250. COST_OF_ACQUISITION
  251. DECLARARTION_DATE
  252.  
  253.  
  254. EIS_EMP_INVESTMENT (Table)
  255. EIS_INVESTMENT_ID
  256. EIS_EMPLOYEE_CODE
  257. INVESTMENT_DETAILS
  258. INVESTMENT_AMOUNT
  259.  
  260.  
  261. EIS_EMP_LEAVES (Table)
  262. EIS_LEAVES_ID
  263. EIS_EMPLOYEE_CODE
  264. LEAVES_TYPE
  265. NUMBER_LEAVES
  266. FROM_DATE
  267. TO_DATE
  268. LEAVES_DATE
  269. LEAVES_LFP_TYPE
  270.  
  271.  
  272. EIS_EMP_LIABALITIES_PAID (Table)
  273. EIS_LIABALITIES_PAID_ID
  274. EIS_EMPLOYEE_CODE
  275. LIABALITIES_DETAILS
  276. LIABALITIES_AMOUNT
  277.  
  278.  
  279. EIS_EMP_LOAN (Table)
  280. EIS_EMP_LOAN_ID
  281. EIS_EMPLOYEE_CODE
  282. HS_IS_GET
  283. HS_IS_RETURNED
  284. MCYCLE_IS_GET
  285. MCYCLE_IS_RETURNED
  286. MCAR_IS_GET
  287. MCAR_IS_RETURNED
  288. CYCLE_IS_GET
  289. CYCLE_IS_RETURNED
  290. GP_IS_GET
  291. GP_IS_RETURNED
  292. EIS_LOAN_BANK_NAME
  293. BANK_IS_GET
  294. BANK_IS_RETURNED
  295.  
  296.  
  297. EIS_EMP_MEMBERSHIP (Table)
  298. EIS_MEMBERSHIP_ID
  299. EIS_EMPLOYEE_CODE
  300. MEMBER_ORGANIZATION
  301. ORGANIZATION_ADDRESS
  302. MEMBERSHIP_DATE
  303. EIS_MEMBERSHIP_CHECKED
  304.  
  305.  
  306. EIS_EMP_MOVEABLE_ASSETS (Table)
  307. MOVEABLE_ID
  308. EIS_EMPLOYEE_CODE
  309. IDENTIFICATION_AND_NATURE
  310. MODE_OF_ACQUISITION
  311. COST_OF_ACQUISITION
  312. DECLARARTION_DATE
  313.  
  314.  
  315. EIS_EMP_PENSION (Table)
  316. EIS_PENSION_ID
  317. EIS_EMPLOYEE_CODE
  318. PENSION_TYPE
  319. PENSION_DATE
  320. COMMUTATION_AMOUNT
  321. AMOUNT_PER_MONTH
  322. GROUP_AMOUNT
  323. FUND_AMOUNT
  324. GRATUATY_AMOUNT
  325. LIS_REMARKS
  326.  
  327.  
  328. EIS_EMP_PICTURE_SIGNATURE (Table)
  329. EIS_EMP_PICTURE_ID
  330. EIS_EMPLOYEE_CODE
  331.  
  332.  
  333. EIS_EMP_SPOUSE (Table)
  334. EIS_EMP_SPOUSE_ID
  335. EIS_EMP_SPOUSE_NAME
  336. EIS_EMP_CODE
  337. WORKTYPE
  338. NIC
  339. DOB
  340.  
  341.  
  342. EIS_EMP_TOTAL_ASSETS (Table)
  343. EIS_TOTAL_ASSETS_ID
  344. EIS_EMPLOYEE_CODE
  345. TOTAL_AMOUNT
  346.  
  347.  
  348. EIS_IMAGES (Table)
  349. IMAGE_ID
  350. IMAGE_NAME
  351. IMAGE_TYPE
  352. IMAGE_SIZE
  353.  
  354.  
  355. EIS_JOINING_TPYE (Table)
  356. EIS_JOINING_TYPE_ID
  357. EIS_DESCRIPTION
  358.  
  359.  
  360. EIS_LANGUAGE (Table)
  361. EIS_LANGUAGE_ID
  362. EIS_NAME
  363.  
  364.  
  365. EIS_ORGANIZATION (Table)
  366. EIS_ORGANIZATION_ID
  367. EIS_NAME
  368.  
  369.  
  370. EIS_PERSONAL_INFORMATION (Table)
  371. EIS_EMPLOYEE_CODE
  372. EIS_WORK_ID
  373.  
  374.  
  375. EIS_PERSONAL_INFORMATION (Table)
  376. EIS_COUNTRY_ID
  377. EIS_DOMICILE_ID
  378. EIS_EMPLOYEE_NAME
  379. EIS_DATE_OF_BIRTH
  380. EIS_WORK_DATE
  381. EIS_FATHER_NAME
  382. EIS_RELIGION
  383. EIS_GENDER
  384. EIS_BLOOD_GROUP
  385. EIS_ID_MARK
  386. EIS_NIC_NO
  387. EIS_NIT_NO
  388. EIS_EOBI_NO
  389. EIS_PASSPORT_NO
  390. EIS_MARITAL_STATUS
  391. EIS_BASIC_SCALE
  392. EIS_NO_SPOUSE
  393. EIS_NIC_OLD
  394. EIS_NEXT_KIN
  395. EIS_NEXT_KIN_RELATION
  396. EIS_SUPER_ANNOVATION_DATE
  397. EIS_FILE_NUMBER
  398. EIS_TERMINATION_DATE
  399. EIS_CADRE
  400. EIS_SENIORITY_LEVEL
  401.  
  402.  
  403. EIS_POSTING_INFO_FPSC (Table)
  404. EIS_POSTING_ID
  405. EIS_WING_ID
  406. EIS_DESIGNATION_ID
  407. EIS_EMPLOYEE_CODE
  408. EIS_FROM_DATE
  409. EIS_TO_DATE
  410. EIS_BASIC_SCALE
  411.  
  412.  
  413. EIS_PRE_FPSC_SERVICE (Table)
  414. EIS_PRE_SERVICE_ID
  415. EIS_DESIGNATION_ID
  416. EIS_COUNTRY_ID
  417. EIS_ORGANIZATION_ID
  418. EIS_EMPLOYEE_CODE
  419. EIS_FROM_DATE
  420. EIS_TO_DATE
  421. EIS_PLACE
  422. EIS_LEAVING_REASON
  423.  
  424.  
  425. EIS_PROMOTION_INFORMATION (Table)
  426. EIS_PROMOTION_ID
  427. EIS_EMPLOYEE_CODE
  428. EIS_DESIGNATION_ID
  429. EIS_WING_ID
  430. EIS_PROMOTION_DATE
  431. EIS_BASIC_SCALE
  432.  
  433.  
  434. EIS_RECORD_APPROVED (Table)
  435. EIS_RECORD_APR_ID
  436. EIS_EMPLOYEE_CODE
  437. EIS_STATUS
  438. EIS_GENERATE_ACCOUNT
  439.  
  440.  
  441. EIS_RELIGION (Table)
  442. EIS_RELIGION_ID
  443. EIS_RELIGION_NAME
  444.  
  445.  
  446. EIS_SERVICE_RECORD (Table)
  447. EIS_SERVICE_ID
  448. EIS_JOINING_TYPE_ID
  449. EIS_EMPLOYEE_CODE
  450. EIS_JOINING_DATE
  451. EIS_JOINING_BS
  452. EIS_JOINING_DESIGNATION_ID
  453. EIS_JOINING_WING_ID
  454. EIS_CONFIRMATION_DATE
  455. EIS_PRESENT_BPS
  456. EIS_PRESENT_DESIGNATION_ID
  457. EIS_PRESENT_WING_ID
  458.  
  459.  
  460. EIS_SPECIALIZATION (Table)
  461. EIS_SPECIALIZATION_ID
  462. EIS_NAME
  463.  
  464.  
  465. EIS_SPECIALIZATION_COURSES (Table)
  466. EIS_SPEC_COURSE_ID
  467. EIS_COURSE_ID
  468. EIS_COUNTRY_ID
  469. EIS_EMPLOYEE_CODE
  470. EIS_ORGANIZATION_ID
  471. EIS_SPECIALIZATION_ID
  472. EIS_MAJOR_SUBJECT
  473. EIS_FROM_DATE
  474. EIS_TO_DATE
  475.  
  476.  
  477. EIS_TECHNICAL_PUBLICATION (Table)
  478. EIS_TECH_PUB_ID
  479. EIS_EMPLOYEE_CODE
  480. EIS_SUBJECT_TITLE
  481. EIS_NAME_OF_JOURNAL
  482. EIS_ISSUE_NO
  483. EIS_ISSUE_DATE
  484.  
  485.  
  486. EIS_UNIVERSITY (Table)
  487. EIS_UNIVERSITY_ID
  488. EIS_UNIVERSITY_NAME
  489.  
  490.  
  491. EIS_USER_ACCOUNT (Table)
  492. EIS_ACCOUNT_NO
  493. EIS_RECORD_APR_ID
  494. EIS_EMAIL_ADDRESS
  495. EIS_USER_NAME
  496. EIS_PASSWORD
  497.  
  498.  
  499. EIS_WING (Table)
  500. EIS_WING_ID
  501. EIS_NAME
  502.  
  503.  
  504. EIS_WORK_STATUS (Table)
  505. EIS_WORK_ID
  506. EIS_TYPE_OF_WORK
  507.  
  508.  
  509. EXAMINAR_INFO (Table)
  510. EXAMINER_CODE
  511. EXAMINER_NAME
  512. FATHER_NAME
  513. POSTAL_ADDRESS1
  514. POSTAL_ADDRESS2
  515. PERMANENT_ADDRESS1
  516. PERMANENT_ADDRESS2
  517. DOB
  518. GENDER
  519. MARITAL
  520. DISTRICT_ID
  521. PHONE_COLLEGE
  522. PHONE_RES
  523. EMAIL
  524. MOBILE
  525. NIC_NEW
  526. NIC_OLD
  527. CITY
  528. FAX
  529. EXAMINER_APPOINTED
  530. EXAMINER_APPOINTED_DATE
  531. EX_DATEADDED
  532.  
  533.  
  534. EXAMINATION_DETAIL (Table)
  535. GR_EXPERIENCE_ID
  536. GR_POST_NAME
  537. GR_ORGANIZATION_NAME
  538. GR_FROM_DATE
  539. GR_TO_DATE
  540. GR_ORGANIZATION_TYPE
  541. GR_JOB_STATUS
  542. GR_MAIN_DUTIES
  543. GR_JOB_NATURE
  544. GR_ORGANIZATION_ID
  545. GR_APPLICANT_ID
  546.  
  547.  
  548. EX_ACADEMIC_QUALIFICATION (Table)
  549. EX_QUALIFICATION_ID
  550. EXAMINER_CODE
  551. EX_UNIVERSITY_ID
  552. EX_EXAMINATION_NAME
  553. EX_RESULT_DATE
  554. EX_GRADE
  555. EX_DIVISION
  556. EX_BOARD_OTHER
  557. EX_MAJOR_COURSE_WORKS
  558. EX_CGP
  559.  
  560.  
  561. EX_BILLING_DETAIL (Table)
  562. EXAMINAR_BILLING_DETAIL_IDS
  563. EXAMINER_ID
  564. EXAMINER_BILLING_DATE
  565. PAPER_SUBJECT
  566. PAPER_TYPE
  567. PREPARE_FEE
  568. MARK_PAPER
  569. MARK_FEE
  570. INCOME_TAX_DEDUCT_RATE
  571. LETTER_TO
  572. EXAMINATION_NAME
  573. SETTING_TOTAL
  574. SETTING_PRICE
  575. TOTAL_SETTING_PRICE
  576. MARKING_TOTAL
  577. MARKING_PRICE
  578. TOTAL_MARKING_PRICE
  579. TOTAL_CO_MARKING_PRICE
  580. CO_MARKING_TOTAL
  581. POSTAGE_PRICE
  582. TELEGRAPH_PRICE
  583. CONVEYANCE_PRICE
  584. MS_PRICE
  585. GRAND_TOTAL_PRICE
  586. GRAND_PRICE_IN_WORDS
  587. PLACE
  588. DATE_ADDED
  589. COORD_CO_MARKING_PRICE
  590.  
  591.  
  592. EX_CANTER_PAPERS_INFO (Table)
  593. EX_PAPER_INFO_ID
  594. EX_DATE
  595. EX_SUB_ID
  596. EX_NO_Q
  597. EX_NO_P
  598. EX_REMARKS
  599. EX_DATEADDED
  600. EX_CENTER_ID
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!