https://www.tdbenefitsandpension.com/en/modules/pension/epp/planinformation/taxissues.asp
contribute:
The company: ympe*1.4%
The personal (with topup): (x-ympe)*5.5%
Pension adjustment for RRSP room:
ympe*1.4%*9+(x-ympe)*2%*9-600
Pension calculation:
(average_ympe*1.4%+(x-average_ympe)*2%)*service_year
Thursday, November 23, 2017
Canada PR Card Renewal 2
http://www.cic.gc.ca/english/information/pr-card/apply-how.asp
http://www.cic.gc.ca/english/helpcentre/results-by-topic.asp?st=4.2
http://www.cic.gc.ca/english/information/applications/guides/5445ETOC.asp#5445E4
UCI Look for this number on PR card
TODO:
1. Input SIN card number
2. A clear and legible photocopy of Paul's birth certificate
3. Write the name of the applicant on the envelope
4. Pay the fee
5. Fill out all sections. If a section does not apply to you, write “Not Applicable” or “NA”.
After you pay, a copy of your receipt will be emailed to you. Print it and include it with your paper application.
1. IMM 5644: Document checklist - Application for a Permanent Resident Card
Write your Unique Client Identifier (UCI) in the box at the top right hand corner. Your UCI
is an 8 or 10 digit reference number that appears on all correspondence you receive from IRCC.
Send the completed checklist with your application.
2. Your PR Card
If you are applying to renew your present card, you should keep it until you get your new card.
3. One (1) main identity document
A photocopy of your valid passport or travel document. First page with the photo
4. Photos
Put the two (2) photos in a small envelope (no staples or paper clips), and
Write the name of the applicant on the envelope.
If you are under the age of 18
A clear and legible photocopy of your birth certificate (showing your name, date of birth, place of birth and the names of
your parents or adoptive parents);
Use another page if you need more space to list this information.
5. IMM5444E.pdf
Fill out all sections. If a section does not apply to you, write “Not Applicable” or “NA”.
Pay the fees
3x $50 = 150$ You must pay your fees online.
http://www.cic.gc.ca/english/information/fees/pay.asp
Do not exit without printing the receipt! The receipt you printed is your proof of payment.
Mail the application
If your application is properly completed and you meet the requirements for a PR Card
If you gave us a valid email address, we will send you an Acknowledgement of Receipt (AoR) of your application;
you will get your card in the mail or a letter from us telling you when and where to pick up your card.
If you are still working or studying, or if you still live at that address, write “TODAY” or the date
you are signing the application. If you do not know the exact dates, provide approximate dates.
If you are an existing permanent resident who has received their PR card in the past, you will most likely also
receive your renewed PR card by mail.
You should destroy your old PR card once you receive the renewed card. If you receive your new PR card in the mail,
you should destroy your old card. If you are asked to pick up your new PR card from a IRCC office, you must bring your
existing PR card with you.
http://www.cic.gc.ca/english/helpcentre/results-by-topic.asp?st=4.2
http://www.cic.gc.ca/english/information/applications/guides/5445ETOC.asp#5445E4
UCI Look for this number on PR card
TODO:
1. Input SIN card number
2. A clear and legible photocopy of Paul's birth certificate
3. Write the name of the applicant on the envelope
4. Pay the fee
5. Fill out all sections. If a section does not apply to you, write “Not Applicable” or “NA”.
After you pay, a copy of your receipt will be emailed to you. Print it and include it with your paper application.
1. IMM 5644: Document checklist - Application for a Permanent Resident Card
Write your Unique Client Identifier (UCI) in the box at the top right hand corner. Your UCI
is an 8 or 10 digit reference number that appears on all correspondence you receive from IRCC.
Send the completed checklist with your application.
2. Your PR Card
If you are applying to renew your present card, you should keep it until you get your new card.
3. One (1) main identity document
A photocopy of your valid passport or travel document. First page with the photo
4. Photos
Put the two (2) photos in a small envelope (no staples or paper clips), and
Write the name of the applicant on the envelope.
If you are under the age of 18
A clear and legible photocopy of your birth certificate (showing your name, date of birth, place of birth and the names of
your parents or adoptive parents);
Use another page if you need more space to list this information.
5. IMM5444E.pdf
Fill out all sections. If a section does not apply to you, write “Not Applicable” or “NA”.
Pay the fees
3x $50 = 150$ You must pay your fees online.
http://www.cic.gc.ca/english/information/fees/pay.asp
Do not exit without printing the receipt! The receipt you printed is your proof of payment.
Mail the application
If your application is properly completed and you meet the requirements for a PR Card
If you gave us a valid email address, we will send you an Acknowledgement of Receipt (AoR) of your application;
you will get your card in the mail or a letter from us telling you when and where to pick up your card.
If you are still working or studying, or if you still live at that address, write “TODAY” or the date
you are signing the application. If you do not know the exact dates, provide approximate dates.
If you are an existing permanent resident who has received their PR card in the past, you will most likely also
receive your renewed PR card by mail.
You should destroy your old PR card once you receive the renewed card. If you receive your new PR card in the mail,
you should destroy your old card. If you are asked to pick up your new PR card from a IRCC office, you must bring your
existing PR card with you.
Canada PR Card renewal 1
https://www.wenba.ca/article/5522
据加拿大新的入境规定，从2016年3月15日起，免签证入境加拿大的旅客必须持有 eTA 才能乘坐飞机入境加拿大
持有中国护照及有效加拿大签证的人群不需要 eTA。
加拿大永久居民乘飞机进入加拿大无需持有 eTA，但需持有有效枫叶卡入境
Application for a Permanent Resident Card一共有四页，首先大家要在第一张右上角的box里填上自己的UCI Number，也就是我们PR Card上的8位数ID No
算离境日期时，不包括离开加拿大的当日，但需要包括返回加拿大的日期。
9月15日CIC更新了办理手续。好象要求的材料比以前少而简单得多
1. One main identity document: A photocopy of valid passport
2. You will need two (2) identical photos taken within six (6) months of the date of this application:
Put the two (2) photos in a small envelope (no staples or paper clips), and
Write the name of the applicant on the envelope.
If you are under the age of 18
A clear and legible photocopy of birth certificate
3.
Permanent Resident Card x $50
You must pay your fees online. Do not exit without printing the receipt
4.
Mail the application
5.
If you gave us a valid email address, we will send you an Acknowledgement of Receipt (AoR) of your application
You will get your card in the mail or a letter from us telling you when and where to pick up your card.
http://www.cic.gc.ca/english/information/times/index.asp
Renewing or replacing a PR card
47 days
Most permanent residents in Canada replacing or renewing their PR card will receive it by mail.
Question:
1. Need tax?
不要交税单了？现在不用交了
2. Only need passport first page? 理解正确（只需要首页）
Oracle PL/SQL
A nonpartitioned table can have partitioned or nonpartitioned indexes.
A partitioned table can have partitioned or nonpartitioned indexes.
The partitioning key is comprised of one or more columns that determine the partition where each row will be stored.
To reduce disk usage and memory usage (specifically, the buffer cache), you can store tables and partitions of a partitioned
table in a compressed format inside the database. This often leads to a better scaleup for read-only operations. Table compression
can also speed up query execution. There is, however, a slight cost in CPU overhead.
Just like partitioned tables, partitioned indexes improve manageability, availability, performance, and scalability.
They can either be partitioned independently (global indexes) or automatically linked to a table's partitioning method (local indexes).
In general, you should use global indexes for OLTP applications and local indexes for data warehousing or DSS applications.
Also, whenever possible, you should try to use local indexes because they are easier to manage.
1. If the table partitioning column is a subset of the index keys, use a local index.
2. If the index is unique and does not include the partitioning key columns, then use a global index.
3. If your priority is manageability, use a local index.
4. If the application is an OLTP one and users need quick response times, use a global index. If the application is a
DSS one and users are more interested in throughput, use a local index.
(My note: prefer to use local index unless the index is unique and not part of the partitioned column)
unique column can have multiiple null values
The explain plan is what the optimizer thinks will happen when you run, the execution plan is actually happened when you ran the query.
Well, Oracle isn't quite that smart. In this case, Oracle knew (or in most cases it's a good guess) we would process 100 rows because we
generated statistics on the EMP table after we created the table. The optimizer uses these statistics to generate execution plans.
the autotrace statistics reported however are FACTS, after executing the statement, not guesses, not part of optimization.
SQL does not treat NULL values as zeros when calculating SUM, it ignores them.
This makes a difference only in one case - when the sequence being totalled up does not contain numeric items, only NULLs: if at least one number is present, the result is going to be numeric.
From official:
Autotrace report is generated after successful SQL DML (that is, SELECT, DELETE, UPDATE and INSERT) statements.
The execution plan shows the SQL optimizer's query execution path.
The statistics are recorded by the server when your statement executes and indicate the system resources required to execute your statement.
The maximum length string that SQLERRM will return is 512 bytes, call DBMS_UTILITY.FORMAT_ERROR_STACK for full message.
DBMS_UTILITY.FORMAT_ERROR_BACKTRACE to see the line number.
A left outer join returns all the values from an inner join plus all values in the left table that do not match to the right table.
The read committed transaction isolation level is the Oracle default
Indexed TABLE:
DECLARE
TYPE ename_table_type IS TABLE OF emp.ename%TYPE
INDEX BY BINARY_INTEGER;
ename_table ename_table_type;
B*Tree index is used mostly (one key to one row/range) while Bitmap index is used for low cardinality data (Y,N and null).
UNION, INTERSECT and MINUS are ordered by the first column while UNION ALL is not ordered.
A partitioned table can have partitioned or nonpartitioned indexes.
The partitioning key is comprised of one or more columns that determine the partition where each row will be stored.
To reduce disk usage and memory usage (specifically, the buffer cache), you can store tables and partitions of a partitioned
table in a compressed format inside the database. This often leads to a better scaleup for read-only operations. Table compression
can also speed up query execution. There is, however, a slight cost in CPU overhead.
Just like partitioned tables, partitioned indexes improve manageability, availability, performance, and scalability.
They can either be partitioned independently (global indexes) or automatically linked to a table's partitioning method (local indexes).
In general, you should use global indexes for OLTP applications and local indexes for data warehousing or DSS applications.
Also, whenever possible, you should try to use local indexes because they are easier to manage.
1. If the table partitioning column is a subset of the index keys, use a local index.
2. If the index is unique and does not include the partitioning key columns, then use a global index.
3. If your priority is manageability, use a local index.
4. If the application is an OLTP one and users need quick response times, use a global index. If the application is a
DSS one and users are more interested in throughput, use a local index.
(My note: prefer to use local index unless the index is unique and not part of the partitioned column)
unique column can have multiiple null values
The explain plan is what the optimizer thinks will happen when you run, the execution plan is actually happened when you ran the query.
Well, Oracle isn't quite that smart. In this case, Oracle knew (or in most cases it's a good guess) we would process 100 rows because we
generated statistics on the EMP table after we created the table. The optimizer uses these statistics to generate execution plans.
the autotrace statistics reported however are FACTS, after executing the statement, not guesses, not part of optimization.
SQL does not treat NULL values as zeros when calculating SUM, it ignores them.
This makes a difference only in one case - when the sequence being totalled up does not contain numeric items, only NULLs: if at least one number is present, the result is going to be numeric.
From official:
Autotrace report is generated after successful SQL DML (that is, SELECT, DELETE, UPDATE and INSERT) statements.
The execution plan shows the SQL optimizer's query execution path.
The statistics are recorded by the server when your statement executes and indicate the system resources required to execute your statement.
The maximum length string that SQLERRM will return is 512 bytes, call DBMS_UTILITY.FORMAT_ERROR_STACK for full message.
DBMS_UTILITY.FORMAT_ERROR_BACKTRACE to see the line number.
A left outer join returns all the values from an inner join plus all values in the left table that do not match to the right table.
The read committed transaction isolation level is the Oracle default
Indexed TABLE:
DECLARE
TYPE ename_table_type IS TABLE OF emp.ename%TYPE
INDEX BY BINARY_INTEGER;
ename_table ename_table_type;
B*Tree index is used mostly (one key to one row/range) while Bitmap index is used for low cardinality data (Y,N and null).
UNION, INTERSECT and MINUS are ordered by the first column while UNION ALL is not ordered.
Thursday, November 2, 2017
健身计划
健身计划
1. 周三、周六
篮球
2. 周日
Meditation
3. 周二、四
平板支撑、深蹲、倒立
4. 周一、周五
俯卧撑
每天早上 Meditation
Google Calendar记录
1. 周三、周六
篮球
2. 周日
Meditation
3. 周二、四
平板支撑、深蹲、倒立
4. 周一、周五
俯卧撑
每天早上 Meditation
Google Calendar记录
Subscribe to:
Posts (Atom)