Advertisement
Guest User

Cyb3rGh0sts & ANonCyber

a guest
Dec 7th, 2012
5,243
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 49.01 KB | None | 0 0
  1. By: Crlo Lvd & Syztem Schmelzer
  2. Cyb3rGh0sts & AnonCyber
  3.  
  4.  
  5. Marinha dos E.U.A (Navy)
  6.  
  7. ------------------------------------------------------------------------------
  8.  
  9. DAtabases
  10.  
  11. Available databases [3]:
  12. [*] HHG_MGR
  13. [*] SYS
  14. [*] SYSTEM
  15.  
  16. ====TABLES====
  17.  
  18. Database: HHG_MGR
  19. [104 tables]
  20. +--------------------------------+
  21. | ACCOUNT |
  22. | ACCOUNT_ARCH |
  23. | ACCOUNT_TEMP |
  24. | APPLICATION_STATUS |
  25. | APPLICATION_STATUS_ARCH |
  26. | APPLICATION_STATUS_TEMP |
  27. | APPLICATION_STEPS |
  28. | CONTACT_INFO |
  29. | CONTACT_INFO_ARCH |
  30. | DD1299 |
  31. | DD1299_ARCH |
  32. | DEPARTURE_INFO |
  33. | DOM_PPSO_CONTACT_INSTR |
  34. | ELIGIBILITY |
  35. | ELIGIBILITY_ARCH |
  36. | FIREARMS |
  37. | FIREARMS_ARCH |
  38. | HHG_QRESPONSES |
  39. | HHG_QRESPONSES_ARCH |
  40. | HOLIDAY_DATES |
  41. | INSURANCE_ELECTIONS |
  42. | INSURANCE_ELECTIONS_ARCH |
  43. | MEMBER_CONTACT |
  44. | MEMBER_CONTACT_ARCH |
  45. | MEMBER_ORDERS |
  46. | MEMBER_ORDERS_ARCH |
  47. | MOBILE_HOMES |
  48. | MOBILE_HOMES_ARCH |
  49. | MOTORCYCLES |
  50. | MOTORCYCLES_ARCH |
  51. | MOVE_INFO |
  52. | MOVE_INFO_ARCH |
  53. | NEW_DUTY_STATION_INFO |
  54. | NEW_DUTY_STATION_INFO_ARCH |
  55. | NTS_EXTENSION_SHIPMENT |
  56. | NTS_EXTENSION_SHIPMENT_ARCH |
  57. | NTS_RELEASE_SHIPMENT |
  58. | NTS_RELEASE_SHIPMENT_ARCH |
  59. | NTS_SHIPMENT |
  60. | NTS_SHIPMENT_ARCH |
  61. | ORDERS_MASTER |
  62. | ORDERS_MASTER_ARCH |
  63. | PERSONNEL |
  64. | POINT_OF_CONTACT |
  65. | POINT_OF_CONTACT_ARCH |
  66. | POV |
  67. | POV_ARCH |
  68. | PPCIG_CONSUMABLES |
  69. | PPCIG_CONSUMABLES_SPECIFICS |
  70. | PPCIG_COUNTRY_CODE |
  71. | PPCIG_COUNTRY_INFO |
  72. | PPCIG_COUNTRY_INFO_WEIGHTS |
  73. | PPCIG_COUNTRY_WEIGHTS |
  74. | PPCIG_CUSTOMS_CLEARANCE |
  75. | PPCIG_CUSTOMS_CLEARANCE_SPEC |
  76. | PPCIG_ELECTRICAL_EQUIPMENT |
  77. | PPCIG_ELECTRIC_EQUIPMENT_SPEC |
  78. | PPCIG_FIREARMS |
  79. | PPCIG_FIREARMS_SPECIFICS |
  80. | PPCIG_FURNITURE |
  81. | PPCIG_FURNITURE_SITE_SPECIFICS |
  82. | PPCIG_FURNITURE_SPECIFICS |
  83. | PPCIG_OTHER |
  84. | PPCIG_OTHER_SITE_SPECIFICS |
  85. | PPCIG_OTHER_SPECIFICS |
  86. | PPCIG_PETS |
  87. | PPCIG_PETS_SPECIFICS |
  88. | PPCIG_PORN |
  89. | PPCIG_PORN_SPECIFICS |
  90. | PPCIG_POV |
  91. | PPCIG_POV_SPECIFICS |
  92. | PPCIG_SEPARATION |
  93. | PPCIG_SEPARATION_SITE_SPEC |
  94. | PPCIG_SERVICE_CODE |
  95. | PPCIG_SHIP_INSTRUCTIONS |
  96. | PPCIG_SHIP_INSTRUCTIONS_SPEC |
  97. | PPCIG_STUFFED_WILDLIFE |
  98. | PPCIG_STUFF_WILDLIFE_SITE_SPEC |
  99. | PPCIG_SUBCHAPTER |
  100. | PPCIG_TRANSMIT_EQUIPMENT |
  101. | PPCIG_TRANSMIT_EQUIP_SITE_SPEC |
  102. | PPM_INFO |
  103. | PPM_INFO_ARCH |
  104. | PROCESSING_CENTERS |
  105. | RELEASE_ITEMS |
  106. | RELEASE_ITEMS_ARCH |
  107. | SHIPMENT |
  108. | SHIPMENT_ARCH |
  109. | SHIPMENT_SUPPLEMENT |
  110. | SHIPMENT_SUPPLEMENT_ARCH |
  111. | SHIP_ADDL_ADDRESSES |
  112. | SHIP_ADDL_ADDRESSES_ARCH |
  113. | SHIP_ADDRESSES |
  114. | SHIP_ADDRESSES_ARCH |
  115. | SHIP_WEIGHTS |
  116. | SHIP_WEIGHTS_ARCH |
  117. | SURVEY |
  118. | SWM_QUEUE |
  119. | SWM_QUEUE_ARCH |
  120. | TOAD_PLAN_TABLE |
  121. | UNUSUAL_OVERSIZE_ITEMS |
  122. | UNUSUAL_OVERSIZE_ITEMS_ARCH |
  123. | WEIGHT_ENTITLEMENT |
  124. | ZIP_TO_GBLOC |
  125. +--------------------------------+
  126.  
  127. Database: SYS
  128. [24 tables]
  129. +-------------------------------+
  130. | HS_PARALLEL_METADATA |
  131. | KUNOEXP_TAB |
  132. | KU_DATAPUMP_MASTER_10_1 |
  133. | KU_DATAPUMP_MASTER_11_1 |
  134. | KU_DATAPUMP_MASTER_11_1_0_7 |
  135. | KU_DATAPUMP_MASTER_11_2 |
  136. | KU_LIST_FILTER_TEMP |
  137. | KU_LIST_FILTER_TEMP_2 |
  138. | ODCI_PMO_ROWIDS |
  139. | ODCI_SECOBJ |
  140. | ODCI_WARNINGS |
  141. | PLAN_TABLE |
  142. | WRI_ADV_ASA_RECO_DATA |
  143. | WRR_REPLAY_CALL_FILTER |
  144. | AUDIT_ACTIONS |
  145. | DUAL |
  146. | HS_BULKLOAD_VIEW_OBJ |
  147. | HS_PARTITION_COL_NAME |
  148. | HS_PARTITION_COL_TYPE |
  149. | IMPDP_STATS |
  150. | PSTUBTBL |
  151. | STMT_AUDIT_OPTION_MAP |
  152. | SYSTEM_PRIVILEGE_MAP |
  153. | TABLE_PRIVILEGE_MAP |
  154. +-------------------------------+
  155.  
  156. Database: SYSTEM
  157. [4 tables]
  158. +-----------+
  159. | OL |
  160. | OLHINTS |
  161. | OLNODES |
  162. | HELP |
  163. +-----------+
  164.  
  165.  
  166. ====COLUMNS====
  167.  
  168. Database: HHG_MGR
  169. Table: ACCOUNT
  170. [18 columns]
  171. +------------------------+----------+
  172. | Column | Type |
  173. +------------------------+----------+
  174. | ACTIVE_FLAG | VARCHAR2 |
  175. | ADMIN_FLAG | VARCHAR2 |
  176. | ASSIGNED_COUNSELOR_ID | VARCHAR2 |
  177. | CONFIRMATION_STRING | VARCHAR2 |
  178. | COUNSELOR_NOTES | VARCHAR2 |
  179. | DISTINGUISHED_NAME | VARCHAR2 |
  180. | DUPLICATE | CHAR |
  181. | LAST_ACTIVE_DATE | DATE |
  182. | ORDERS_SERIAL_KEY | NUMBER |
  183. | PASSWORD_CREATED_DATE | DATE |
  184. | PASSWORD_HINT | VARCHAR2 |
  185. | PROC_PROCESSING_CENTER | VARCHAR2 |
  186. | SESSION_ID | VARCHAR2 |
  187. | SSN | VARCHAR2 |
  188. | SUBMIT_DATE | DATE |
  189. | TOPS_SUBMIT_DATE | DATE |
  190. | USER_PASSWORD | VARCHAR2 |
  191. | USERNAME | VARCHAR2 |
  192. +------------------------+----------+
  193. Database: HHG_MGR
  194. Table: DD1299
  195. [11 columns]
  196. +-------------------------------+----------+
  197. | Column | Type |
  198. +-------------------------------+----------+
  199. | DATE_DD1299_PRINTED | DATE |
  200. | DD1299_BLOCK13_REMARKS | VARCHAR2 |
  201. | DD1299_DATE_PREPARED | DATE |
  202. | DD1299_MAILED_IN | VARCHAR2 |
  203. | DD1299_PREPARING_INSTALLATION | VARCHAR2 |
  204. | DD1299_REASON_NO_SIGNATURE | VARCHAR2 |
  205. | DD1299MAIL_OUT | VARCHAR2 |
  206. | NAME_OF_CERTIFYING_OFFICER | VARCHAR2 |
  207. | ORDERS_SERIAL_KEY | NUMBER |
  208. | SHIPMENT_NUMBER | NUMBER |
  209. | TITLE_OF_CERTIFYING_OFFICER | VARCHAR2 |
  210. +-------------------------------+----------+
  211. Database: HHG_MGR
  212. Table: DEPARTURE_INFO
  213. [15 columns]
  214. +-----------------+--------+
  215. | Column | Type |
  216. +-----------------+--------+
  217. | ABBR_POV | CLOB |
  218. | BOAT | CLOB |
  219. | CONSUMABLES | CLOB |
  220. | COUNTRY_INFO_ID | NUMBER |
  221. | CUSTOMS | CLOB |
  222. | FIREARM | CLOB |
  223. | FURNITURE | CLOB |
  224. | HOUSING | CLOB |
  225. | JETSKI | CLOB |
  226. | MISCELLANEOUS | CLOB |
  227. | MOTORCYCLE | CLOB |
  228. | PET | CLOB |
  229. | PLANT | CLOB |
  230. | PORN | CLOB |
  231. | POV | CLOB |
  232. +-----------------+--------+
  233. Database: HHG_MGR
  234. Table: FIREARMS
  235. [7 columns]
  236. +-------------------+----------+
  237. | Column | Type |
  238. +-------------------+----------+
  239. | FARM_CALIBER | VARCHAR2 |
  240. | FARM_MAKE | VARCHAR2 |
  241. | FARM_MODEL | VARCHAR2 |
  242. | FARM_SERIAL_NBR | VARCHAR2 |
  243. | FARM_VALUE | NUMBER |
  244. | ORDERS_SERIAL_KEY | NUMBER |
  245. | SHIPMENT_NUMBER | NUMBER |
  246. +-------------------+----------+
  247. Database: HHG_MGR
  248. Table: INSURANCE_ELECTIONS
  249. [3 columns]
  250. +-------------------+----------+
  251. | Column | Type |
  252. +-------------------+----------+
  253. | ORDERS_SERIAL_KEY | NUMBER |
  254. | SHIPMENT_NUMBER | NUMBER |
  255. | TYPE_OF_INSURANCE | VARCHAR2 |
  256. +-------------------+----------+
  257. Database: HHG_MGR
  258. Table: MEMBER_CONTACT
  259. [36 columns]
  260. +--------------------------------+----------+
  261. | Column | Type |
  262. +--------------------------------+----------+
  263. | DESTINATION_SPONSOR_NAME | VARCHAR2 |
  264. | DESTINATION_SPONSOR_PHONE | VARCHAR2 |
  265. | DESTINATION_SPONSOR_PHONE_EXT | VARCHAR2 |
  266. | HHG_CONTACT_NAME | VARCHAR2 |
  267. | HHG_INTRANSIT_CONTACT_NAME | VARCHAR2 |
  268. | HHG_STORAGE_COMPANY_NAME | VARCHAR2 |
  269. | HHG_STORAGE_LOT_ID | VARCHAR2 |
  270. | HHG_STORAGE_PHONE | VARCHAR2 |
  271. | HHG_STORAGE_PHONE_EXT | VARCHAR2 |
  272. | MBR_DEST_CONT_PHONE_NUMBER_EXT | VARCHAR2 |
  273. | MBR_DEST_CONTACT_CITY | VARCHAR2 |
  274. | MBR_DEST_CONTACT_COUNTRY | VARCHAR2 |
  275. | MBR_DEST_CONTACT_PHONE_NUMBER | VARCHAR2 |
  276. | MBR_DEST_CONTACT_STATE | VARCHAR2 |
  277. | MBR_DEST_CONTACT_STREET | VARCHAR2 |
  278. | MBR_DEST_CONTACT_ZIP_APO_FPO | VARCHAR2 |
  279. | MBR_DEST_DUTY_PHONE_NUMBER | VARCHAR2 |
  280. | MBR_DEST_DUTY_PHONE_NUMBER_EXT | VARCHAR2 |
  281. | MBR_INTRANS_CONTACT_PHONE_EXT | VARCHAR2 |
  282. | MBR_INTRANSIT_CARE_OF_NAME | VARCHAR2 |
  283. | MBR_INTRANSIT_CONTACT_CITY | VARCHAR2 |
  284. | MBR_INTRANSIT_CONTACT_COUNTRY | VARCHAR2 |
  285. | MBR_INTRANSIT_CONTACT_PHONE | VARCHAR2 |
  286. | MBR_INTRANSIT_CONTACT_STATE | VARCHAR2 |
  287. | MBR_INTRANSIT_CONTACT_STREET | VARCHAR2 |
  288. | MBR_INTRANSIT_ZIP_APO_FPO | VARCHAR2 |
  289. | MBR_ORG_DUTY_PHONE_NUMBER_EXT | VARCHAR2 |
  290. | MBR_ORG_HOME_PHONE_NUMBER_EXT | VARCHAR2 |
  291. | MBR_ORIGIN_CONTACT_CITY | VARCHAR2 |
  292. | MBR_ORIGIN_CONTACT_COUNTRY | VARCHAR2 |
  293. | MBR_ORIGIN_CONTACT_STATE | VARCHAR2 |
  294. | MBR_ORIGIN_CONTACT_STREET | VARCHAR2 |
  295. | MBR_ORIGIN_CONTACT_ZIP_APO_FPO | VARCHAR2 |
  296. | MBR_ORIGIN_DUTY_PHONE_NUMBER | VARCHAR2 |
  297. | MBR_ORIGIN_HOME_PHONE_NUMBER | VARCHAR2 |
  298. | ORDERS_SERIAL_KEY | NUMBER |
  299. +--------------------------------+----------+
  300. Database: HHG_MGR
  301. Table: MEMBER_ORDERS
  302. [57 columns]
  303. +--------------------------------+----------+
  304. | Column | Type |
  305. +--------------------------------+----------+
  306. | ACCOMPANIED_TOUR_OVERSEAS | VARCHAR2 |
  307. | ACCOUNTING_CLASSIFICATION | VARCHAR2 |
  308. | ADMIN_RESTRICTED_WEIGHT | NUMBER |
  309. | ADMIN_WEIGHT_ADJUSTMENT | NUMBER |
  310. | APPROXIMATE_REPORTING_DATE | DATE |
  311. | CHARGE_WT_TO_SPON_MBR_ORDERS | VARCHAR2 |
  312. | COMBINED_MOVE_SPOUSE_IN_SERV | VARCHAR2 |
  313. | COUNSELOR_INITIALS | VARCHAR2 |
  314. | CURRENT_DUTY_STATION | VARCHAR2 |
  315. | DEPENDENT_TRAVEL_AUTHORIZED | VARCHAR2 |
  316. | DEPENDENT_TRAVEL_CONCURRENT | VARCHAR2 |
  317. | DEPENDENT_TRAVEL_DELAYED | VARCHAR2 |
  318. | DEPENDENT_UB_TABULAR_WEIGHT | NUMBER |
  319. | DEPLOYMENT_MOVE | VARCHAR2 |
  320. | FULL_JTR_TABULAR_WEIGHT_PCS | NUMBER |
  321. | FULL_JTR_TABULAR_WEIGHT_TDY | NUMBER |
  322. | IB_FILE_FOLDER_LABEL_PRINTED | VARCHAR2 |
  323. | JOINT_MOVE_SPOUSE_IN_SERVICE | VARCHAR2 |
  324. | MBR_CHOOSES_UB_SURFACE_ALTERN | VARCHAR2 |
  325. | MEMBER_BRANCH_OF_SERVICE | VARCHAR2 |
  326. | MEMBER_FISCAL_YEAR_OF_DETACH | NUMBER |
  327. | MEMBER_IN_PAY_STATUS_AT_DEST | VARCHAR2 |
  328. | MEMBER_MOVING_TO_GOVT_HOUSING | VARCHAR2 |
  329. | MEMBER_NAVY_RANK_RATE_CODE | VARCHAR2 |
  330. | MEMBER_OVER_2_YEARS_SERVICE | VARCHAR2 |
  331. | MEMBER_PAY_GRADE | VARCHAR2 |
  332. | MEMBER_RANK | VARCHAR2 |
  333. | MEMBER_UB_TABULAR_WEIGHT | NUMBER |
  334. | MOVEMENT_DESIGNATOR_CODE | VARCHAR2 |
  335. | NAVY_NMF_CODE | VARCHAR2 |
  336. | NEW_DUTY_STATION | VARCHAR2 |
  337. | NTS_FILE_FOLDER_LABEL_PRINTED | VARCHAR2 |
  338. | NUMBER_OF_DEPENDENTS_UNDER_12 | NUMBER |
  339. | NUMBER_OF_DEPN_12_AND_OVER | NUMBER |
  340. | OB_FILE_FOLDER_LABEL_PRINTED | VARCHAR2 |
  341. | OLD_ISSUING_HQTRS | VARCHAR2 |
  342. | OLD_ORDERS_DATE | DATE |
  343. | ORDERS_AMENDED | VARCHAR2 |
  344. | ORDERS_DATE | DATE |
  345. | ORDERS_ISSUING_HEADQUARTERS | VARCHAR2 |
  346. | ORDERS_PARAGRAPH_NUMBER | VARCHAR2 |
  347. | ORDERS_SERIAL_KEY | NUMBER |
  348. | PCS_WITH_TDY_INDICATOR | VARCHAR2 |
  349. | RETIREMENT_SEPARATION_DATE | DATE |
  350. | SPONSORED_DEPENDENT_FIRST_NAME | VARCHAR2 |
  351. | SPONSORED_DEPENDENT_LAST_NAME | VARCHAR2 |
  352. | SPONSORED_DEPENDENT_MOVE | VARCHAR2 |
  353. | SPONSORED_DEPN_MID_NAM_OR_INIT | VARCHAR2 |
  354. | SPONSORING_MBR_ORDERS_NUMBER | VARCHAR2 |
  355. | SPONSORING_MEMBER_ORDERS_DATE | DATE |
  356. | TIMESTAMP | DATE |
  357. | TOUR_OVERSEAS | VARCHAR2 |
  358. | TRANSPORTATION_ACCOUNT_CODE | VARCHAR2 |
  359. | TYPE_OF_ORDERS | VARCHAR2 |
  360. | UB_WEIGHT_ADJUSTMENT | NUMBER |
  361. | UNIT_GAINING_MEMBER | VARCHAR2 |
  362. | UNIT_LOSING_MEMBER | VARCHAR2 |
  363. +--------------------------------+----------+
  364. Database: HHG_MGR
  365. Table: MOBILE_HOMES
  366. [17 columns]
  367. +--------------------+----------+
  368. | Column | Type |
  369. +--------------------+----------+
  370. | MOBH_ADDRESS | VARCHAR2 |
  371. | MOBH_CITY | VARCHAR2 |
  372. | MOBH_COUNTRY | VARCHAR2 |
  373. | MOBH_EXPANDABLE | VARCHAR2 |
  374. | MOBH_HEIGHT | VARCHAR2 |
  375. | MOBH_LENGTH | VARCHAR2 |
  376. | MOBH_MAKE | VARCHAR2 |
  377. | MOBH_MODEL | VARCHAR2 |
  378. | MOBH_STATE | VARCHAR2 |
  379. | MOBH_TRANSPORTABLE | VARCHAR2 |
  380. | MOBH_TYPE | VARCHAR2 |
  381. | MOBH_WIDTH | VARCHAR2 |
  382. | MOBH_YEAR | NUMBER |
  383. | MOBH_ZIPCODE | VARCHAR2 |
  384. | MOBH_ZIPCODE_EXT | VARCHAR2 |
  385. | ORDERS_SERIAL_KEY | NUMBER |
  386. | SHIPMENT_NUMBER | NUMBER |
  387. +--------------------+----------+
  388. Database: HHG_MGR
  389. Table: MOVE_INFO
  390. [9 columns]
  391. +--------------------+----------+
  392. | Column | Type |
  393. +--------------------+----------+
  394. | DUPLICATE | CHAR |
  395. | IN_GOVT_STORAGE | VARCHAR2 |
  396. | MEMB_SSN | VARCHAR2 |
  397. | MOVE_TYPE | VARCHAR2 |
  398. | OCONUS_MOVE | VARCHAR2 |
  399. | ORDERS_SERIAL_KEY | NUMBER |
  400. | RECENT_MOVE | VARCHAR2 |
  401. | WEIGHT_ENTITLEMENT | NUMBER |
  402. | YEARS_IN_SERVICE | VARCHAR2 |
  403. +--------------------+----------+
  404. Database: HHG_MGR
  405. Table: NEW_DUTY_STATION_INFO
  406. [16 columns]
  407. +-------------------+----------+
  408. | Column | Type |
  409. +-------------------+----------+
  410. | ARRIVAL_DATE | DATE |
  411. | CITY | VARCHAR2 |
  412. | COUNTRY | VARCHAR2 |
  413. | DSN | VARCHAR2 |
  414. | DUPLICATE | CHAR |
  415. | HOMEPORT | VARCHAR2 |
  416. | MEMB_SSN | VARCHAR2 |
  417. | NEW_DUTY_STATION | VARCHAR2 |
  418. | ORDERS_SERIAL_KEY | NUMBER |
  419. | RECEIPT_DATE | DATE |
  420. | STATE | VARCHAR2 |
  421. | STREET_ADDRESS | VARCHAR2 |
  422. | WORK_PHONE | VARCHAR2 |
  423. | WORK_PHONE_EXT | VARCHAR2 |
  424. | ZIPCODE | VARCHAR2 |
  425. | ZIPCODE_EXT | VARCHAR2 |
  426. +-------------------+----------+
  427. Database: HHG_MGR
  428. Table: NTS_EXTENSION_SHIPMENT
  429. [9 columns]
  430. +----------------------+----------+
  431. | Column | Type |
  432. +----------------------+----------+
  433. | DATE_OF_STORAGE | DATE |
  434. | DATE_TO_EXTENSION | DATE |
  435. | LOT_NUMBER | VARCHAR2 |
  436. | NTS_LOCATION_NUMBER | NUMBER |
  437. | ORDERS_SERIAL_KEY | NUMBER |
  438. | RESPONSIBLE_PPO | VARCHAR2 |
  439. | SERVICE_ORDER_NUMBER | VARCHAR2 |
  440. | SHIPMENT_NUMBER | NUMBER |
  441. | WEIGHT | VARCHAR2 |
  442. +----------------------+----------+
  443. Database: HHG_MGR
  444. Table: NTS_RELEASE_SHIPMENT
  445. [9 columns]
  446. +----------------------+----------+
  447. | Column | Type |
  448. +----------------------+----------+
  449. | DATE_OF_STORAGE | DATE |
  450. | DATE_TO_RELEASE | DATE |
  451. | LOT_NUMBER | VARCHAR2 |
  452. | NTS_LOCATION_NUMBER | NUMBER |
  453. | ORDERS_SERIAL_KEY | NUMBER |
  454. | RESPONSIBLE_PPO | VARCHAR2 |
  455. | SERVICE_ORDER_NUMBER | VARCHAR2 |
  456. | SHIPMENT_NUMBER | NUMBER |
  457. | WEIGHT | VARCHAR2 |
  458. +----------------------+----------+
  459. Database: HHG_MGR
  460. Table: NTS_SHIPMENT
  461. [65 columns]
  462. +--------------------------------+----------+
  463. | Column | Type |
  464. +--------------------------------+----------+
  465. | CURRENT_NTS_PRO_GEAR_WT | NUMBER |
  466. | CURRENT_NTS_STORED_WT | NUMBER |
  467. | DATE_CONVERTED_TO_MBR_EXPENSE | DATE |
  468. | DATE_NEW_APPROP_EFFECTIVE | DATE |
  469. | DATE_NTS_EXPIR_LETTER1_PRINTED | DATE |
  470. | DATE_NTS_EXPIR_LETTER2_PRINTED | DATE |
  471. | DATE_NTS_EXTENSION_AUTHORIZED | DATE |
  472. | DATE_QTRLY_STG_INVOICE_PRINTED | DATE |
  473. | ESTIMATED_NTS_REMOVAL_DATE | DATE |
  474. | ESTIMATED_PERIOD_OF_NTS | NUMBER |
  475. | FINANCE_OFFICE_CODE | VARCHAR2 |
  476. | HHG_ALT_CONTACT_NAME | VARCHAR2 |
  477. | HHG_ALT_CONTACT_PHONE_COM | VARCHAR2 |
  478. | HHG_ALT_CONTACT_PHONE_DSN | VARCHAR2 |
  479. | HHG_ALT_CONTACT_PHONE_EXT | VARCHAR2 |
  480. | HHG_LT_CONTACT_RELATIONSHIP | VARCHAR2 |
  481. | MBR_PERM_ADDR_CARE_OF_NAME | VARCHAR2 |
  482. | MBR_PERMANENT_ADDR_CITY | VARCHAR2 |
  483. | MBR_PERMANENT_ADDR_COUNTRY | VARCHAR2 |
  484. | MBR_PERMANENT_ADDR_PH_COM | VARCHAR2 |
  485. | MBR_PERMANENT_ADDR_PH_DSN | VARCHAR2 |
  486. | MBR_PERMANENT_ADDR_PHONE_EXT | VARCHAR2 |
  487. | MBR_PERMANENT_ADDR_STATE | VARCHAR2 |
  488. | MBR_PERMANENT_ADDR_STREET | VARCHAR2 |
  489. | MBR_PERMANENT_ADDR_ZIP_APO_FPO | VARCHAR2 |
  490. | MINIMUM_WEIGHT_VALUE | NUMBER |
  491. | NEW_APPROPRIATION_IDENT_CODE | VARCHAR2 |
  492. | NTS_ACTION | VARCHAR2 |
  493. | NTS_APPROPRIATION_IDENT_CODE | VARCHAR2 |
  494. | NTS_BOA_MOD_NUMBER | VARCHAR2 |
  495. | NTS_BOA_MOD_STATUS_CODE | VARCHAR2 |
  496. | NTS_BOA_NUMBER | VARCHAR2 |
  497. | NTS_CONSTR_WT_USED_INDICATOR | VARCHAR2 |
  498. | NTS_CONTRACTOR_CODE | VARCHAR2 |
  499. | NTS_ENTITLEMT_EXPIRATION_DATE | DATE |
  500. | NTS_EXT_AUTH | VARCHAR2 |
  501. | NTS_EXTENSION_AUTHORITY | VARCHAR2 |
  502. | NTS_EXTENSION_REASON | VARCHAR2 |
  503. | NTS_FEDERAL_AGENCY | VARCHAR2 |
  504. | NTS_LOT_NUMBER | VARCHAR2 |
  505. | NTS_MULT_SHIPMT_SEQ_NUM | NUMBER |
  506. | NTS_PENDING_OVERSEAS_SHIPMENT | VARCHAR2 |
  507. | NTS_PRO_GEAR_AUTHORIZED | VARCHAR2 |
  508. | NTS_RESPONSIBLE_GBLOC | VARCHAR2 |
  509. | NTS_SERVICE_ORDER_NUMBER | VARCHAR2 |
  510. | NTS_TYPE | VARCHAR2 |
  511. | NUMBER_OF_MONTHS_NTS_AUTH | NUMBER |
  512. | OLD_BOA_MOD_NUMBER | VARCHAR2 |
  513. | OLD_BOA_NUMBER | VARCHAR2 |
  514. | OLD_CONTRACTOR_CODE | VARCHAR2 |
  515. | OLD_DATE_APPROP_EFFECTIVE | DATE |
  516. | OLD_ENTITLEMT_EXPIR_DATE | DATE |
  517. | OLD_MONTHS_AUTH | NUMBER |
  518. | OLD_NTS_BOA_MOD_STATUS_CODE | VARCHAR2 |
  519. | OLD_NTS_LOT_NUMBER | VARCHAR2 |
  520. | OLD_NTS_SERVICE_ORDER_NUMBER | VARCHAR2 |
  521. | ORDERS_SERIAL_KEY | NUMBER |
  522. | PART_OF_DEPLOYMENT_INDICATOR | VARCHAR2 |
  523. | SHIPMENT_NUMBER | NUMBER |
  524. | SPECIAL_RATE_REQUIRED | VARCHAR2 |
  525. | SPECTRANS_STG_FAC_ID | VARCHAR2 |
  526. | SPECTRANS_TCD_UPDATED | VARCHAR2 |
  527. | STG_PERIOD_BEFORE_NEW_APPROP | NUMBER |
  528. | STORAGE_FACILITY_ID | VARCHAR2 |
  529. | WGT_STORED_AT_MBR_EXPENSE | NUMBER |
  530. +--------------------------------+----------+
  531. Database: HHG_MGR
  532. Table: ORDERS_MASTER
  533. [8 columns]
  534. +-----------------------+----------+
  535. | Column | Type |
  536. +-----------------------+----------+
  537. | MBR_OSK | NUMBER |
  538. | MEMB_FIRST_NAME | VARCHAR2 |
  539. | MEMB_LAST_NAME | VARCHAR2 |
  540. | MEMB_MID_NAME_OR_INIT | VARCHAR2 |
  541. | MEMB_SSN | VARCHAR2 |
  542. | OLD_ORDERS_NUMBER | VARCHAR2 |
  543. | ORDERS_NUMBER | VARCHAR2 |
  544. | ORDERS_SERIAL_KEY | NUMBER |
  545. +-----------------------+----------+
  546. Database: HHG_MGR
  547. Table: PERSONNEL
  548. [18 columns]
  549. +-----------------------+----------+
  550. | Column | Type |
  551. +-----------------------+----------+
  552. | ALT_DSN | VARCHAR2 |
  553. | ALT_PHONE | VARCHAR2 |
  554. | ALT_PHONE_EXT | VARCHAR2 |
  555. | DSN | VARCHAR2 |
  556. | EFFECTIVE_DATE | DATE |
  557. | EFFECTIVE_DELETE_DATE | DATE |
  558. | EMAIL | VARCHAR2 |
  559. | FAX | VARCHAR2 |
  560. | FIRST_NAME | VARCHAR2 |
  561. | INITIALS | VARCHAR2 |
  562. | LAST_NAME | VARCHAR2 |
  563. | MID_NAME_OR_INIT | VARCHAR2 |
  564. | PROCESSING_CENTER | VARCHAR2 |
  565. | SUPERVISOR_ID | VARCHAR2 |
  566. | TEAM_ID | VARCHAR2 |
  567. | USERNAME | VARCHAR2 |
  568. | WORK_PHONE | VARCHAR2 |
  569. | WORK_PHONE_EXT | VARCHAR2 |
  570. +-----------------------+----------+
  571. Database: HHG_MGR
  572. Table: POINT_OF_CONTACT
  573. [14 columns]
  574. +-------------------+----------+
  575. | Column | Type |
  576. +-------------------+----------+
  577. | CITY | VARCHAR2 |
  578. | CONTACT_NAME | VARCHAR2 |
  579. | CONTACT_TYPE | VARCHAR2 |
  580. | COUNTRY | VARCHAR2 |
  581. | DSN | VARCHAR2 |
  582. | DUPLICATE | CHAR |
  583. | MEMB_SSN | VARCHAR2 |
  584. | ORDERS_SERIAL_KEY | NUMBER |
  585. | PHONE | VARCHAR2 |
  586. | PHONE_EXT | VARCHAR2 |
  587. | STATE | VARCHAR2 |
  588. | STREET_ADDRESS | VARCHAR2 |
  589. | ZIPCODE | VARCHAR2 |
  590. | ZIPCODE_EXT | VARCHAR2 |
  591. +-------------------+----------+
  592. Database: HHG_MGR
  593. Table: POV
  594. [9 columns]
  595. +----------------------------+----------+
  596. | Column | Type |
  597. +----------------------------+----------+
  598. | IS_POV_DRIVABLE | VARCHAR2 |
  599. | ORDERS_SERIAL_KEY | NUMBER |
  600. | POV_IDENTIFICATION_NUMBER | VARCHAR2 |
  601. | POV_LICENSE_NUMBER | VARCHAR2 |
  602. | POV_LICENSE_STATE_OF_ISSUE | VARCHAR2 |
  603. | POV_MAKE | VARCHAR2 |
  604. | POV_MODEL | VARCHAR2 |
  605. | POV_YEAR | NUMBER |
  606. | SHIPMENT_NUMBER | NUMBER |
  607. +----------------------------+----------+
  608. Database: HHG_MGR
  609. Table: PPCIG_CUSTOMS_CLEARANCE
  610. [5 columns]
  611. +-------------------+--------+
  612. | Column | Type |
  613. +-------------------+--------+
  614. | CUSTOMS_ID | NUMBER |
  615. | DD1434 | CLOB |
  616. | GENERAL_INS | CLOB |
  617. | INTRATHEATER_SHIP | CLOB |
  618. | PERSONAL_PROPERTY | CLOB |
  619. +-------------------+--------+
  620. Database: HHG_MGR
  621. Table: PPCIG_CUSTOMS_CLEARANCE_SPEC
  622. [3 columns]
  623. +--------------+----------+
  624. | Column | Type |
  625. +--------------+----------+
  626. | CUSTOMS_ID | NUMBER |
  627. | INSTRUCTIONS | CLOB |
  628. | SUBJECT | VARCHAR2 |
  629. +--------------+----------+
  630. Database: HHG_MGR
  631. Table: PPCIG_ELECTRICAL_EQUIPMENT
  632. [5 columns]
  633. +---------------+--------+
  634. | Column | Type |
  635. +---------------+--------+
  636. | ELECTRICAL_ID | NUMBER |
  637. | HOME_PC | CLOB |
  638. | OTHER | CLOB |
  639. | RADIO | CLOB |
  640. | TVS | CLOB |
  641. +---------------+--------+
  642. Database: HHG_MGR
  643. Table: PPCIG_ELECTRIC_EQUIPMENT_SPEC
  644. [4 columns]
  645. +---------------+----------+
  646. | Column | Type |
  647. +---------------+----------+
  648. | ELECTRICAL_ID | NUMBER |
  649. | GBLOC | VARCHAR2 |
  650. | INSTRUCTIONS | CLOB |
  651. | SUBJECT | VARCHAR2 |
  652. +---------------+----------+
  653. Database: HHG_MGR
  654. Table: PPCIG_FIREARMS
  655. [6 columns]
  656. +-------------+--------+
  657. | Column | Type |
  658. +-------------+--------+
  659. | FIREARMS_ID | NUMBER |
  660. | GENERAL_INS | CLOB |
  661. | HANDGUNS | CLOB |
  662. | OTHER | CLOB |
  663. | RIFLES | CLOB |
  664. | TOY_GUNS | CLOB |
  665. +-------------+--------+
  666. Database: HHG_MGR
  667. Table: PPCIG_POV
  668. [15 columns]
  669. +----------------------+--------+
  670. | Column | Type |
  671. +----------------------+--------+
  672. | CONSIGNMENT | CLOB |
  673. | DOCUMENTATION | CLOB |
  674. | GASOLINE_INS | CLOB |
  675. | GENERAL_INS | CLOB |
  676. | INSURANCE_INS | CLOB |
  677. | MODIFIED_VEHICLE | CLOB |
  678. | MOTORCYCLE_INS | CLOB |
  679. | OTHER | CLOB |
  680. | POV_ID | NUMBER |
  681. | REGISTRATION | CLOB |
  682. | REPAIRS | CLOB |
  683. | SAFETY_REQUIREMENTS | CLOB |
  684. | SNOW | CLOB |
  685. | VEHICLE_AVAILABILITY | CLOB |
  686. | WAIVERS | CLOB |
  687. +----------------------+--------+
  688. Database: HHG_MGR
  689. Table: PPCIG_SERVICE_CODE
  690. [2 columns]
  691. +--------------+----------+
  692. | Column | Type |
  693. +--------------+----------+
  694. | DESCRIPTION | VARCHAR2 |
  695. | SERVICE_CODE | VARCHAR2 |
  696. +--------------+----------+
  697. Database: HHG_MGR
  698. Table: PPCIG_SHIP_INSTRUCTIONS
  699. [6 columns]
  700. +---------------------+--------+
  701. | Column | Type |
  702. +---------------------+--------+
  703. | CONTAINER | CLOB |
  704. | GENERAL_WEIGHT_INFO | CLOB |
  705. | HARD_LIFT | CLOB |
  706. | OTHER | CLOB |
  707. | SHIP_INS_ID | NUMBER |
  708. | UNACCOMPANIED_BAG | CLOB |
  709. +---------------------+--------+
  710. Database: HHG_MGR
  711. Table: PPCIG_SHIP_INSTRUCTIONS_SPEC
  712. [4 columns]
  713. +--------------+----------+
  714. | Column | Type |
  715. +--------------+----------+
  716. | GBLOC | VARCHAR2 |
  717. | INSTRUCTIONS | CLOB |
  718. | SHIP_INS_ID | NUMBER |
  719. | SUBJECT | VARCHAR2 |
  720. +--------------+----------+
  721. Database: HHG_MGR
  722. Table: PPCIG_TRANSMIT_EQUIPMENT
  723. [6 columns]
  724. +-------------------+--------+
  725. | Column | Type |
  726. +-------------------+--------+
  727. | AMATEUR_HAM_RADIO | CLOB |
  728. | CB | CLOB |
  729. | CORDLESS_PHONE | CLOB |
  730. | DISH | CLOB |
  731. | MARS_EQUIPMENT | CLOB |
  732. | TRANSMIT_ID | NUMBER |
  733. +-------------------+--------+
  734. Database: HHG_MGR
  735. Table: PPCIG_TRANSMIT_EQUIP_SITE_SPEC
  736. [4 columns]
  737. +--------------+----------+
  738. | Column | Type |
  739. +--------------+----------+
  740. | GBLOC | VARCHAR2 |
  741. | INSTRUCTIONS | CLOB |
  742. | SUBJECT | VARCHAR2 |
  743. | TRANSMIT_ID | NUMBER |
  744. +--------------+----------+
  745. Database: HHG_MGR
  746. Table: PPM_INFO
  747. [11 columns]
  748. +---------------------------+----------+
  749. | Column | Type |
  750. +---------------------------+----------+
  751. | AUTH_DESTINATION_CITY | VARCHAR2 |
  752. | AUTH_DESTINATION_STATE | VARCHAR2 |
  753. | AUTH_ORIGIN_CITY | VARCHAR2 |
  754. | AUTH_ORIGIN_STATE | VARCHAR2 |
  755. | EST_SPOUSE_PRO_GEAR | NUMBER |
  756. | ESTIMATED_PRO_GEAR_WEIGHT | NUMBER |
  757. | ESTIMATED_WEIGHT | NUMBER |
  758. | MOVE_DATE | DATE |
  759. | MOVE_NUMBER | NUMBER |
  760. | ORDERS_SERIAL_KEY | NUMBER |
  761. | SHIPMENT_NUMBER | NUMBER |
  762. +---------------------------+----------+
  763. Database: HHG_MGR
  764. Table: PROCESSING_CENTERS
  765. [8 columns]
  766. +-------------------+----------+
  767. | Column | Type |
  768. +-------------------+----------+
  769. | BRANCH_OF_SERVICE | VARCHAR2 |
  770. | COUNTRY_CODE | VARCHAR2 |
  771. | COUNTY_CITY_IND | VARCHAR2 |
  772. | COUNTY_CITY_NAME | VARCHAR2 |
  773. | DESCRIPTION | VARCHAR2 |
  774. | GBLOC | VARCHAR2 |
  775. | GMT_DIFFERENCE | NUMBER |
  776. | STATE | VARCHAR2 |
  777. +-------------------+----------+
  778. Database: HHG_MGR
  779. Table: RELEASE_ITEMS
  780. [4 columns]
  781. +-------------------+----------+
  782. | Column | Type |
  783. +-------------------+----------+
  784. | DESCRIPTION | VARCHAR2 |
  785. | ITEM_NBR | NUMBER |
  786. | ORDERS_SERIAL_KEY | NUMBER |
  787. | SHIPMENT_NUMBER | NUMBER |
  788. +-------------------+----------+
  789. Database: HHG_MGR
  790. Table: SHIPMENT
  791. [96 columns]
  792. +--------------------------------+----------+
  793. | Column | Type |
  794. +--------------------------------+----------+
  795. | ADDITIONAL_SERVICE_REQUIRED | VARCHAR2 |
  796. | AGENT_CODE | VARCHAR2 |
  797. | AUTHORIZED_DISTANCE | NUMBER |
  798. | BLUEBARK_MIA_AUTH_SIGNER_NAME | VARCHAR2 |
  799. | BLUEBARK_MIA_AUTH_SIGNER_TITLE | VARCHAR2 |
  800. | CANCEL_OUTBOUND_PART_OF_SHIPMT | VARCHAR2 |
  801. | CARRIER_CODE | VARCHAR2 |
  802. | CODE_OF_SERVICE | VARCHAR2 |
  803. | CODE_OF_SERVICE_FOR_EXCESS_EST | VARCHAR2 |
  804. | CONS_SHIP_NO | VARCHAR2 |
  805. | CONSUMABLES_AUTHORIZED | VARCHAR2 |
  806. | DATE_CANCELLATION_REQUESTED | DATE |
  807. | DATE_COMPLETE_SHIPMENT_ARRIVED | DATE |
  808. | DATE_FAX_PRINTED | DATE |
  809. | DATE_GBL_PRINTED | DATE |
  810. | DATE_SERV_NOTE_PRINTED | DATE |
  811. | DATE_SHIPMENT_COUNSELED | DATE |
  812. | DATE_SHIPMENT_PICKED_UP | DATE |
  813. | DECLARED_VALUATION_AMOUNT | NUMBER |
  814. | DEPLOYMENT_MOVE_NUMBER | VARCHAR2 |
  815. | DESTINATION_DPM_ZONE | VARCHAR2 |
  816. | DESTINATION_GBLOC | VARCHAR2 |
  817. | DESTINATION_RATE_AREA | VARCHAR2 |
  818. | DIRECT_DELIVERY_REQUESTED | VARCHAR2 |
  819. | DPM_SHIPMENT_IND | VARCHAR2 |
  820. | DPM_ZONE | VARCHAR2 |
  821. | DTGBL_ORIGIN_ZONE | VARCHAR2 |
  822. | EXCESS_COST_ESTIMATE | NUMBER |
  823. | EXCESS_COST_PRECOLLECTED | NUMBER |
  824. | EXCESS_COST_TO_PRECOLLECT | NUMBER |
  825. | EXCESS_COSTS_EXIST | VARCHAR2 |
  826. | EXPENSIVE_ITEMS_NO_OF_CARTONS | NUMBER |
  827. | EXPORT_SHIPMENT_INFO_TO_DEST | VARCHAR2 |
  828. | GBL_NUMBER | VARCHAR2 |
  829. | GOCS_ORDERED | VARCHAR2 |
  830. | INSPECTION_REQUESTED_AT_DEST | VARCHAR2 |
  831. | IS_OCONUS | VARCHAR2 |
  832. | LOCAL_MOVE_INDICATOR | VARCHAR2 |
  833. | MBR_CODE_MODE_PREFERENCE | VARCHAR2 |
  834. | MBR_REQUESTED_DELIVERY_DATE | DATE |
  835. | MBR_REQUESTED_PICKUP_DATE | DATE |
  836. | MBR_WILLING_TO_PAY_C_C_PREFER | VARCHAR2 |
  837. | MBR_WILLING_TO_PAY_CODE_PREFER | VARCHAR2 |
  838. | MEMBER_REQUESTED_PACK_DATE | DATE |
  839. | MEMBER_REQUESTED_PACK_DATE_2 | DATE |
  840. | MEMBER_REQUESTED_PACK_DATE_3 | DATE |
  841. | METHOD_OF_SHIPMENT | VARCHAR2 |
  842. | NTS_MULT_SHIPMT_IND | VARCHAR2 |
  843. | NTS_MULT_SHIPMT_SEQ_NUM | NUMBER |
  844. | NTS_MULT_UNPACKING_REQUIRED | VARCHAR2 |
  845. | NUMBER_OF_SPLIT_PORTIONS | NUMBER |
  846. | OLD_SHIPMT_ACCT_CLASS | VARCHAR2 |
  847. | ONE_TIME_ONLY_INDICATOR | VARCHAR2 |
  848. | OPERATING_ALLOW_AMOUNT_ADVANCE | NUMBER |
  849. | OPERATING_ALLOWANCE_AMOUNT | NUMBER |
  850. | ORDERS_SERIAL_KEY | NUMBER |
  851. | ORIGIN_GBLOC | VARCHAR2 |
  852. | ORIGIN_PPPO | VARCHAR2 |
  853. | ORIGIN_RATE_AREA | VARCHAR2 |
  854. | PARCEL_CONSIGNED_TO_DEST_ITO | VARCHAR2 |
  855. | PARCEL_REGISTERED_CERT_NUMBER | VARCHAR2 |
  856. | PARCEL_SERVICE_DATE_SENT | DATE |
  857. | PARCEL_SERVICE_METHOD | VARCHAR2 |
  858. | PARTIAL_DELIVERY_REQUESTED | VARCHAR2 |
  859. | PM_ADVANCE | CHAR |
  860. | PM_TAXES_STATE | CHAR |
  861. | POWER_OF_ATTORNEY_NAME | VARCHAR2 |
  862. | POWER_OF_ATTORNEY_RELATIONSHIP | VARCHAR2 |
  863. | RELEASED_VALUATION_OPTION | VARCHAR2 |
  864. | REMOTE_STAT_NUM_CODE | VARCHAR2 |
  865. | REQUESTED_DISTANCE | NUMBER |
  866. | REQUIRED_DELIVERY_DATE | DATE |
  867. | RESIDENT_PKUP_NUM | NUMBER |
  868. | REWEIGH_NUMBER | VARCHAR2 |
  869. | REWEIGH_REQUESTED_AT_DEST | VARCHAR2 |
  870. | RS_WGT_CHARGE_AGAINST_ENTITLE | VARCHAR2 |
  871. | SHIPMENT_CONTAINS_FIREARMS | VARCHAR2 |
  872. | SHIPMENT_CONTAINS_MOTORCYCLE | VARCHAR2 |
  873. | SHIPMENT_CONTAINS_POV | VARCHAR2 |
  874. | SHIPMENT_NUMBER | NUMBER |
  875. | SHIPMENT_OUT_OF_NTS | VARCHAR2 |
  876. | SHIPMENT_OUT_OF_P_AND_C | VARCHAR2 |
  877. | SHIPMENT_STATUS_CODE | VARCHAR2 |
  878. | SHIPMENT_STATUS_DATE | DATE |
  879. | SHIPMT_ACCOUNT_CLASSIFICATION | VARCHAR2 |
  880. | SHIPMT_CANCELLATION_REQUESTED | VARCHAR2 |
  881. | SPECIAL_SHIPMENT_CIRCUMSTANCE | VARCHAR2 |
  882. | SPLIT_SHIPMENT_INDICATOR | VARCHAR2 |
  883. | TDY_SEGMENT_INDICATOR | VARCHAR2 |
  884. | TIME_FAX_PRINTED | VARCHAR2 |
  885. | TIMESTAMP | DATE |
  886. | TRANSPORTATION_CONTROL_NUMBER | VARCHAR2 |
  887. | TYPE_OF_SHIPMENT | VARCHAR2 |
  888. | VOLUME_MOVE_NUMBER | VARCHAR2 |
  889. | WT_CHARGEABLE_AGAINST_ENTITLE | VARCHAR2 |
  890. | Z_TONNAGE_INDICATOR | VARCHAR2 |
  891. +--------------------------------+----------+
  892. Database: HHG_MGR
  893. Table: SHIPMENT_SUPPLEMENT
  894. [22 columns]
  895. +------------------------+----------+
  896. | Column | Type |
  897. +------------------------+----------+
  898. | GS_RELEASE_TYPE | VARCHAR2 |
  899. | GS_REQUEST_STORAGE_EXT | VARCHAR2 |
  900. | NUM_PACK_DAYS | NUMBER |
  901. | ORDERS_SERIAL_KEY | NUMBER |
  902. | PROF_BOOKS_EQUIP | VARCHAR2 |
  903. | REQ_DELIV_DATE | DATE |
  904. | REQ_PICKUP_DATE_1 | DATE |
  905. | REQ_PICKUP_DATE_2 | DATE |
  906. | REQ_PICKUP_DATE_3 | DATE |
  907. | SHIPMENT_NUMBER | NUMBER |
  908. | SHIPMENT_TYPE | VARCHAR2 |
  909. | SI_BOAT | VARCHAR2 |
  910. | SI_GASOLINE_APPLIANCES | VARCHAR2 |
  911. | SI_JETSKI | VARCHAR2 |
  912. | SI_MOBILEHOME | VARCHAR2 |
  913. | SI_PIANO | VARCHAR2 |
  914. | SI_PLASMA | VARCHAR2 |
  915. | SI_PROPANE_TANK | VARCHAR2 |
  916. | SI_SCUBA | VARCHAR2 |
  917. | SI_UNUSUAL_OVERSIZE | VARCHAR2 |
  918. | SI_UTILITY_TRAILER | VARCHAR2 |
  919. | SI_WASHING_MACHINE | VARCHAR2 |
  920. +------------------------+----------+
  921. Database: HHG_MGR
  922. Table: SHIP_ADDL_ADDRESSES
  923. [36 columns]
  924. +--------------------------------+----------+
  925. | Column | Type |
  926. +--------------------------------+----------+
  927. | ADDL_DEL_DESIG_AGENT_NAME | VARCHAR2 |
  928. | ADDL_DEL_DESIG_AGENT_PH_COM | VARCHAR2 |
  929. | ADDL_DEL_DESIG_AGENT_PH_DSN | VARCHAR2 |
  930. | ADDL_DEL_DESIG_AGENT_PHONE_EXT | VARCHAR2 |
  931. | ADDL_DEL_DESIG_AGENT_RELATN | VARCHAR2 |
  932. | ADDL_DELIVERY_ADDR_CITY | VARCHAR2 |
  933. | ADDL_DELIVERY_ADDR_PHONE | VARCHAR2 |
  934. | ADDL_DELIVERY_ADDR_PHONE_EXT | VARCHAR2 |
  935. | ADDL_DELIVERY_ADDR_STATE | VARCHAR2 |
  936. | ADDL_DELIVERY_ADDR_STREET | VARCHAR2 |
  937. | ADDL_DELIVERY_ADDR_ZIP_APO_FPO | VARCHAR2 |
  938. | ADDL_DELIVERY_COUNTRY | VARCHAR2 |
  939. | ADDL_DELIVERY_COUNTY | VARCHAR2 |
  940. | ADDL_PICKUP_ADDR_CITY | VARCHAR2 |
  941. | ADDL_PICKUP_ADDR_PHONE_NUMBER | VARCHAR2 |
  942. | ADDL_PICKUP_ADDR_STATE | VARCHAR2 |
  943. | ADDL_PICKUP_ADDR_STREET | VARCHAR2 |
  944. | ADDL_PICKUP_ADDR_ZIP_APO_FPO | VARCHAR2 |
  945. | ADDL_PICKUP_COUNTRY | VARCHAR2 |
  946. | ADDL_PICKUP_COUNTY | VARCHAR2 |
  947. | ADDL_PICKUP_DESIG_AGENT_NAME | VARCHAR2 |
  948. | ADDL_PICKUP_DESIG_AGENT_PH_COM | VARCHAR2 |
  949. | ADDL_PICKUP_DESIG_AGENT_PH_DSN | VARCHAR2 |
  950. | ADDL_PICKUP_DESIG_AGENT_RELATN | VARCHAR2 |
  951. | ADDL_PUP_ADDR_PHONE_NUMBER_EXT | VARCHAR2 |
  952. | ADDL_PUP_DESIG_AGENT_PHONE_EXT | VARCHAR2 |
  953. | ADDL_SERVICE_LOCATION | VARCHAR2 |
  954. | HHG_XTRA_DELIV_ALT_CNT_PH_COM | VARCHAR2 |
  955. | HHG_XTRA_DELIV_ALT_CNT_PH_DSN | VARCHAR2 |
  956. | HHG_XTRA_DELIV_TYPE | VARCHAR2 |
  957. | HHG_XTRA_DELIV_WORK_PHONE_COM | VARCHAR2 |
  958. | HHG_XTRA_DELIV_WORK_PHONE_DSN | VARCHAR2 |
  959. | HHG_XTRA_DELIV_WORK_PHONE_EXT | VARCHAR2 |
  960. | HHGXTRA_DDELIV_ALT_CNT_NAME | |
  961. | ORDERS_SERIAL_KEY | NUMBER |
  962. | SHIPMENT_NUMBER | NUMBER |
  963. +--------------------------------+----------+
  964. Database: HHG_MGR
  965. Table: SHIP_ADDRESSES
  966. [45 columns]
  967. +--------------------------------+----------+
  968. | Column | Type |
  969. +--------------------------------+----------+
  970. | AUTHORIZED_DEST_ZIP_APO_FPO | VARCHAR2 |
  971. | AUTHORIZED_DESTINATION_CITY | VARCHAR2 |
  972. | AUTHORIZED_DESTINATION_COUNTRY | VARCHAR2 |
  973. | AUTHORIZED_DESTINATION_COUNTY | VARCHAR2 |
  974. | AUTHORIZED_DESTINATION_STATE | VARCHAR2 |
  975. | AUTHORIZED_ORIGIN_CITY | VARCHAR2 |
  976. | AUTHORIZED_ORIGIN_COUNTRY | VARCHAR2 |
  977. | AUTHORIZED_ORIGIN_COUNTY | VARCHAR2 |
  978. | AUTHORIZED_ORIGIN_STATE | VARCHAR2 |
  979. | AUTHORIZED_ORIGIN_ZIP_APO_FPO | VARCHAR2 |
  980. | DELIVERY_ADDR_PHONE_NUMBER_EXT | VARCHAR2 |
  981. | DELIVERY_ADDRESS_CITY | VARCHAR2 |
  982. | DELIVERY_ADDRESS_PHONE_NUMBER | VACCHAR2 |
  983. | DELIVERY_ADDRESS_STATE | VARCHAR2 |
  984. | DELIVERY_ADDRESS_STREET | VARCHAR2 |
  985. | DELIVERY_ADDRESS_ZIP_APO_FPO | VARCHAR2 |
  986. | DELIVERY_COUNTRY | VARCHAR2 |
  987. | DELIVERY_COUNTY | VARCHAR2 |
  988. | DELIVERY_DESIG_AGENT_NAME | VARCHAR2 |
  989. | DELIVERY_DESIG_AGENT_PHONE_COM | VARCHAR2 |
  990. | DELIVERY_DESIG_AGENT_PHONE_DSN | CR2CHAR2 |
  991. | DELIVERY_DESIG_AGENT_PHONE_EXT | VARCHAR2 |
  992. | DELIVERY_DESIG_AGENT_RELATN | VARCHAR2 |
  993. | HHG_ALT_CONTACT_PHONE_COM | VARCHAR2 |
  994. | HHG_ALT_CONTACT_PHONE_EXT | VARCHAR2 |
  995. | HHG_ALT_CONTT_P_PHONE_DSN | |
  996. | HHG_WORK_PHONE_COM | VARCHAR2 |
  997. | HHG_WORK_PHONE_DSN | VARCHAR2 |
  998. | HHG_WORK_PHONE_EXT | VARCHAR2 |
  999. | ORDERS_SERIAL_KEY | NUMBER |
  1000. | PICKUP_ADDR_PHONE_NUMBER_EXT | VARCHAR2 |
  1001. | PICKUP_ADDRESS_CITY | VARCHAR2 |
  1002. | PICKUP_ADDRESS_PHONE_NUMBER | VARCHAR2 |
  1003. | PICKUP_ADDRESS_STATE | VARCHAR2 |
  1004. | PICKUP_ADDRESS_STREET | VARCHAR2 |
  1005. | PICKUP_ADDRESS_ZIP_APO_FPO | VARCHAR2 |
  1006. | PICKUP_COUNTRY | VARCHAR2 |
  1007. | PICKUP_COUNTY | VARCHAR2 |
  1008. | PICKUP_DESIG_AGENT_NAME | VARCHAR2 |
  1009. | PICKUP_DESIG_AGENT_PHONE_COM | VARCHAR2 |
  1010. | PICKUP_DESIG_AGENT_PHONE_DSN | VARCHAR2 |
  1011. | PICKUP_DESIG_AGENT_PHONE_EXT | VARCHAR2 |
  1012. | PICKUP_DESIG_AGENT_RELATN | VARCHAR2 |
  1013. | SHIPMENT_NUMBER | NUMBER |
  1014. | UNUSUAL_PICKUP_SPECIFICS | VARCHAR2 |
  1015. +--------------------------------+----------+
  1016. Database: HHG_MGR
  1017. Table: SWM_QUEUE
  1018. [7 columns]
  1019. +-----------------------+----------+
  1020. | Column | Type |
  1021. +-----------------------+----------+
  1022. | FILENAME | VARCHAR2 |
  1023. | MEMBER_SSN | VARCHAR2 |
  1024. | ORDERS_NUMBER | VARCHAR2 |
  1025. | ORDERS_SERIAL_KEY | NUMBER |
  1026. | RECORD_PROCESSED_FLAG | VARCHAR2 |
  1027. | SHIPMENT_NUMBER | NUMBER |
  1028. | TTIMESTAMP | DATE |
  1029. +-----------------------+----------+
  1030. Database: HHG_MGR
  1031. Table: TOAD_PLAN_TABLE
  1032. [36 columns]
  1033. +-------------------+----------+
  1034. | Column | Type |
  1035. +-------------------+----------+
  1036. | ACCESS_PREDICATES | VARCHAR2 |
  1037. | BYTES | NUMBER |
  1038. | CARDINALITY | NUMBER |
  1039. | COST | NUMBER |
  1040. | CPU_COST | NUMBER |
  1041. | DEPTH | NUMBER |
  1042. | DISTRIBUTION | VARCHAR2 |
  1043. | FILTER_PREDICATES | VARCHAR2 |
  1044. | ID | NUMBER |
  1045. | IO_COST | NUMBER |
  1046. | OBJECT_ALIAS | VARCHAR2 |
  1047. | OBJECT_INSTANCE | NUMBER |
  1048. | OBJECT_NAME | VARCHAR2 |
  1049. | OBJECT_NODE | VARCHAR2 |
  1050. | OBJECT_OWNER | VARCHAR2 |
  1051. | OBJECT_TYPE | VARCHAR2 |
  1052. | OPERATION | VARCHAR2 |
  1053. | OPTIMIZER | VARCHAR2 |
  1054. | OPTIOSS | |
  1055. | OTHER | LONG |
  1056. | OTHER_TAG | VARCHAR2 |
  1057. | OTHER_XML | CLOB |
  1058. | PARENT_ID | NUMBER |
  1059. | PARTITION_ID | NUMBER |
  1060. | PARTITION_START | VARCHAR2 |
  1061. | PARTITION_STOP | VARCHAR2 |
  1062. | PLAN_ID | NUMBER |
  1063. | POSITION | NUMBER |
  1064. | PROJECTION | VARCHAR2 |
  1065. | QBLOCK_NAME | VARCHAR2 |
  1066. | REMARKS | VARCHAR2 |
  1067. | SEARCH_COLUMNS | NUMBER |
  1068. | STATEMENT_ID | VARCHAR2 |
  1069. | TEMP_SPACE | NUMBER |
  1070. | TIME | NUMBER |
  1071. | TIMESTAMP | DATE |
  1072. +-------------------+----------+
  1073. Database: HHG_MGR
  1074. Table: UNUSUAL_OVERSIZE_ITEMS
  1075. [4 columns]
  1076. +-------------------+----------+
  1077. | Column | Type |
  1078. +-------------------+----------+
  1079. | DESCRIPTION | VARCHAR2 |
  1080. | ITEM_NBR | NUMBER |
  1081. | ORDERS_SERIAL_KEY | NUMBER |
  1082. | SHIPMENT_NUMBER | NUMBER |
  1083. +-------------------+----------+
  1084. Database: HHG_MGR
  1085. Table: ZIP_TO_GBLOC
  1086. [6 columns]
  1087. +---------------+----------+
  1088. | Column | Type |
  1089. +---------------+----------+
  1090. | CITY | VARCHAR2 |
  1091. | COUNTY | VARCHAR2 |
  1092. | GBLOC | VARCHAR2 |
  1093. | LOCATION_CODE | VARCHAR2 |
  1094. | REGION | VARCHAR2 |
  1095. | ZIP_CODE | VARCHAR2 |
  1096. +---------------+----------+
  1097.  
  1098. ====ACCOUNT INFO====
  1099.  
  1100. Database: HHG_MGR
  1101. Table: ACCOUNT
  1102. Ammount pulled: 20/1304
  1103. | ACTIVE_FLAG | ADMIN_FLAG | ASSIGNED_COUNSELOR_ID | CONFIRMATION_STRING | COUNSELOR_NOTES | DISTINGUISHED_NAME | DUPLICATE | LAST_ACTIVE_DATE | ORDERS_SERIAL_KEY | PASSWORD_CREATED_DATE | PASSWORD_HINT | PROC_PROCESSING_CENTER | SESSION_ID | SSN | SUBMIT_DATE | TOPS_SUBMIT_DATE | USER_PASSWORD | USERNAME |
  1104. +-------------+------------+-----------------------+--------------------------------------------+-----------------+---------------------------------------------------------------------------------+----
  1105. | A | S | NULL | SON'S COMBINE NAME:KEVIN AND GREGGORY | NULL | cn=fulgham.octavia.l.1096466931,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 18-APR-03 | NULL | 03-JUN-08 | MICHIGAN | LKNQ | 00691FC30001 | 000-00-0001 | NULL | NULL | 81030BBC191983976F5052583F595CF8 | 4SON8UR@GMAIL.COM |
  1106. | A | C | NULL | WHAT IS YOUR MOTHER'S MAIDEN NAME?:KEODARA | NULL | cn=lopez.aileen.k.1265005272,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 07-SEP-04 | NULL | 29-APR-08 | MOTHER'S MAIDEN NAME | NULL | 009203DF0001 | 000-00-0102 | NULL | NULL | ED10303C8867A67F086F9A1D74C94D4E | 77TWHY77 |
  1107. | A | C | NULL | WHAT IS MY DOGS NAME?:JUNIOR | NULL | cn=lopez.irma.nmn.1231177333,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 02-SEP-04 | NULL | 27-MAY-08 | YOUR DOGS NAME | NULL | 003B021E0001 | 000-00-0103 | NULL | NULL | 8D6602A84EC821F9E114EADD49B70F52 | 818PEZ@EXCITE.COM |
  1108. | A | C | NULL | WHATS MY CHILD'S NAME:ISAIAH | NULL | cn=dean.archelle.l.1231759898,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 03-SEP-04 | NULL | 04-JUN-08 | MY CHILD | LKNQ | 002F02DA0001 | 000-00-0104 | NULL | NULL | 305EC469D779257599B5DF7BC18F263A | A=ADDRAOS@YAHOO.COM |
  1109. | A | S | NULL | SWM12345:SWM12345 | NULL | cn=clark.argraters.1232242937,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 04-AUG-04 | NULL | 05-MAY-08 | SWM12345 | NULL | 007355C80001 | 000-00-0105 | NULL | NULL | 875C0E3F9374D225BDB896A47984E71A | AARONSIEBENS |
  1110. | A | S | NULL | WHAT IS YOUR DOG'S NAME?:SCOUTWILSON | NULL | cn=wilson.charles.edward.1129429964,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 28-MAY-04 | NULL | 19-JUN-08 | SWM12345 | NULL | 007270D50001 | 000-00-0216 | NULL | NULL | DDFA105959B07D80086F9A1D74C94D4E | AATLIM2012 |
  1111. | A | S | NULL | WHAT IS MY MIDDLE NAME:NOTHING | NULL | cn=jones.claudine.1231119775,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 25-JUN-04 | NULL | 17-FEB-06 | JONESY44 | NULL | 009324E80001 | 000-00-2351 | NULL | NULL | 697BA73573BC9B6A7A75B26A3D55B56E | ABE2COPELAND |
  1112. | A | S | NULL | WHO WILL WIN THE SERIES:YANKEES1 | NULL | cn=hancock.david.s.1230301863,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 09-SEP-04 | NULL | 29-APR-08 | WHO WILL WIN THE SERIES | NULL | t9gtxu9jm1.pkbCnAPNahmInAPNpMTIm | 000-00-3247 | NULL | NULL | 10999E2C53DE414FE9114E2604E52E51 | ABX2@COX.NET |
  1113. | A | S | NULL | WHAT IS YOUR DOG'S NAME?:CHIABBA | NULL | cn=nuusolia.eseneiaso.1231722960,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 08-JUN-04 | NULL | 29-MAY-08 | NORMAL PLUS 11 | NULL | 002E03230001 | 000-00-4085 | NULL | NULL | 76E38E68A22BDB9089051C2406D1A310 | AC587447210 |
  1114. | A | S | NULL | WHAT IS MY CAR NAME:JEEP CHEROKEE | NULL | cn=cook.joanne.h.1231669252,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 18-JUN-04 | NULL | 25-FEB-08 | NORMAL11 | NULL | 6wifxybmw1.pkbCnAPNahmInAPNpMTIm | 000-00-4492 | 12-MAR-02 | NULL | 370BF0B577E4EEF3086F9A1D74C94D4E | AC587848082 |
  1115. | A | S | NULL | WHAT IS MY PASSWORD AT HOME:SMILE_44 | NULL | cn=sanborn.dorenda.l.1228609842,ou=usaf,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 02-SEP-04 | NULL | 27-MAR-08 | EARTHLINK | NULL | 009916F90001 | 000-00-5591 | NULL | NULL | A0704B6830EC5AF6EFF66614353E2184 | AD1MEDINA |
  1116. | A | C | NULL | HOW OLD AM I:12345 | NULL | cn=eldert.ines.june.1179390600,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 08-DEC-03 | NULL | 21-APR-08 | WHAT IS MY DOGS NAME | NULL | 00A4037F0001 | 000-00-6166 | NULL | NULL | ED10303C8867A67F086F9A1D74C94D4E | AD554062933 |
  1117. | A | C | NULL | WHAT IS MY SON NAME:BENJAMIN | NULL | cn=brown.sharon.a.1229856339,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 1MA-0R-02 | NULL | 05-MAY-08 | BA | NULL | 005E18160001 | 000-00-6528 | NULL | NULL | B918DEA7FC46BD0BA40C451BFAB2D133 | ADAIRWILLIAM |
  1118. | A | S | NULL | WHAT IS YOUR DOG'S NAME:BABBETT | NULL | cn=watson.betty.s.1229845302,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 25-AUG-04 | NULL | 21-APR-08 | MCKENZIE | NULL | 002F10EE0001 | 000-00-6557 | NULL | NULL | DDFA105959B07D80086F9A1D74C94D4E | ADAM.MCLEOD |
  1119. | A | C | NULL | WHAT IS MY SON'S NAME?:MARLON | NULL | cn=alvaran.jean.a.1174585772,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 10-SEP-04 | NULL | 02-APR-08 | MARLON123 | NULL | jp16ic75p1.pkbCnAPNahmInAPNpMTIm | 000-00-6666 | NULL | NULL | 55FC2C5D6EF9F373086F9A1D74C94D4E | ADAM.MOFFIT@GMAIL.COM |
  1120. | A | S | NULL | FAVORITE LOCAL BAND:DEAD 50S | NULL | cn=sitz.robyn.m.1239515807,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 08-AUG-04 | NULL | 17-JUN-08 | DEAD50S! | NULL | 009915D80001 | 000-00-7009 | NULL | NULL | 3933CEBF87C39EE6E1C5AE40931B8F84 | ADAM.SCHWEGEL@NAVY.MIL |
  1121. | A | S | NULL | WHAT IS YOUR DOG'S NAME?:BUDDY | NULL | cn=swanson.michael.l.1231322988,ou=usaf,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 06-AUG-04 | NULL | 30-MAY-08 | SWM12345 | DBNK | 009B01D50001 | 000-00-7346 | NULL | NULL | 820FCE53C3D61A8CE114EADD49B70F52 | ADAMCLEOOCHS@YAHOO.COM |
  1122. | A | C | DS586608589 | swm12345 | NULL | cn=diaz.nancy.lee.1200127427,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 03-SEP-04 | NULL | 05-MAY-08 | swm12345 | LKNQ | 006862840001 | 000-00-7387 | 01-MAY-02 | NULL | E857D5584861528EBF44FBD95CD4293E | ADAMJOHNPAYNE@GMAIL.COM |
  1123. | A | S | NULL | swm!1234:swm!1234 | NULL | cn=west.dawn.a.1229688312,ou=usn,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 09-MAR-05 | NULL | 21-MAY-08 | swm!1234 | NULL | NULL | 000-00-8548 | NULL | NULL | DDFA105959B07D80086F9A1D74C94D4E | ADENMOHAMED |
  1124. | A | C | NULL | I AM:CHRIST33 | NULL | cn=murphy.kathleen.1228616318,ou=usaf,ou=pki,ou=dod,o=u.s. government,c=us | NULL | 10-FEB-04 | NULL | 08-APR-08 | RELIGION | ALNT | 009B6B250001 | 000-00-9503 | NULL | NULL | ED10303C8867A67F086F9A1D74C94D4E | ADRANSFIELD@COMCAST.NET |
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement