Andy Dufresne

Members
  • Content count

    58,048
  • Joined

  • Last visited

  • Days Won

    1

Andy Dufresne last won the day on April 26 2013

Andy Dufresne had the most liked content!

Community Reputation

2,888 Excellent

About Andy Dufresne

  • Rank
    Footballguy
  • Birthday 12/04/1971

Contact Methods

  • Website URL
    http://
  • ICQ
    0

Profile Information

  • Gender
    Male
  • Location
    The Tardis

Recent Profile Visitors

27,305 profile views
  1. It's mostly a moot point here because I'm really dealing with India/Philippines/Hong Kong/Singapore which aren't going to allow dual citizenship in the application. But of course we need to future proof it as much as possible for regions we haven't rolled out to yet.
  2. Hmmm. Interesting. So they're citizens of American Samoa but US Nationals. Two separate things? Who would issue their passport?
  3. YES! HE MUST BE STOPPED! I was interested in Kong Island until I saw him in the cast. He was the worst part of Kingsman too.
  4. For those of you in the technical realm, what I'm dealing with is that I have a record called CITIZENSHIP that stores...wait for it...citizenship information (Country/Type, etc.). Then there's another page called CITIZEN_PSSPRT that contains passport information. The key fields on this record are EMPLID, DEPENDENT_ID, COUNTRY, PASSPORT_NBR The way that the current online page works is that the parent is citizen information and the child is passport. So you can add citizenship info without adding passport and have to add citizenship before adding passport. But when you add a passport, the key field COUNTRY defaults from the COUNTRY value in CITIZENSHIP. But there's also a field called COUNTRY_PASSPORT which is the Country Of Issue that I've been talking about. So, to sum up, CITIZENSHIP.COUNTRY feeds into CITIZEN_PASSPORT.COUNTRY but then the latter table has a value called COUNTRY_PASSPORT, which is not a key field but is required to be filled in to save the page. The page currently allows you to change this value. I was just wondering if it should really be able to do that. I don't think it should.
  5. Good link. I saw that earlier in the day but then saw something elsewhere that seemed to contradict what that guy was saying.
  6. I called the US Gov directly. It makes no sense that there are two separate values because the Country of Issue has to be a country of which you're a citizen. One country cannot give you a passport for another. If I have dual US/Canada citizenship the US issues me my US passport and Canada issues me my Canadian passport. At least that's what Lisa from US Passports & International Travel told me.
  7. Yes, but the Country of Issue would be the country of citizenship right? Are there any circumstances where your country of citizenship would not equal your Country of Issue? It seems that there must be such a condition otherwise why have two values? But how could one country issue a passport for another? Even in dual citizenship situations, Canada couldn't issue you a US passport, could it?
  8. But in that case your country of citizenship would be Canada and the Country Issuing Passport would also be Canada, right? You wouldn't be issued a Canadian passport by the US would you?
  9. The Perkins situation has a similar vibe to Ajayi's last year, I think. He didn't seem great in his first year even though he got some play. Then as his second season went on he exploded and proved his worth and we wonder how we all missed it and criticized him in the first place. Not that I'm 100% sold on Ajayi yet, but he's definitely upped his value significantly.
  10. I'm working on a project where we're allowing employees to update their own citizenship and passport information. I haven't traveled much at all so I don't know how passports - specificaly multiple passports - are issued. In the passport world, there are different country values - one where its the country of which you're a citizen and the other is something commonly called the "Country Issuing Passport". In short, my question is would these values ever be different? Could you ever be a US citizen but have a passport where the "Country Issuing Passport" is NOT the US? How does multi--citizenship work with passports? There will be a technical (database setup type) follow up question after a general understanding.
  11. Kelce side. And I drafted Shepard pretty much everywhere I could last year.
  12. Living and dying by the rookies, I guess. Would be nice if Samuel is categorized as a RB.