SCC_TEMP_ID1=Yes
2=No
N=No (A)
Y=Yes (A)
Default Value: N
Prompt Table: CAN_PROV_CITZ
Y/N Table Edit
SSR_STG_CNRP_ST(SQL Table) |
Index Back |
|---|---|
Student Report (CAN)* Sac-r75-19990831 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_TEMP_ID |
Number(16,0) | DECIMAL(16) NOT NULL | Temp Constituent ID |
| 2 | CAN_ESIS_SENS_REC | Character(1) | VARCHAR2(1) NOT NULL |
Sac-r75-19990831
1=Yes 2=No N=No (A) Y=Yes (A) Default Value: N |
| 3 | CAN_ESIS_NSN | Character(30) | VARCHAR2(30) NOT NULL | Sac-r75-19990831 |
| 4 | CAN_PROV_FUND_CITZ | Character(6) | VARCHAR2(6) NOT NULL |
Funding Class By Citiz
Sac-r75-19990831: Classifies students by citizenship for grant purposes in accordance with the funding agency's policy. Leave this element blank if your institution does not report this information to the provincial ministry or other agency.
Prompt Table: CAN_PROV_CITZ |
| 5 | CAN_ESIS_APPR | Character(1) | VARCHAR2(1) NOT NULL |
SAC-R75-19990831
Y/N Table Edit |
| 6 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By |
| 7 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |
| 8 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By |
| 9 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |