USF_PIR_NAMEPIR_AGENCY_NAMEPIR_DFN_HDR(SQL Table) |
Index Back |
|---|---|
PIR_DFN_HDRPIR Definition Header Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | USF_PIR_NAME |
Character(40) | VARCHAR2(40) NOT NULL | PIR Input System Name |
| 2 | PIR_AGENCY_NAME |
Character(4) | VARCHAR2(4) NOT NULL | PIR Agency Name |
| 3 | DATE_ID | Character(8) | VARCHAR2(8) NOT NULL | Date ID for PIR File Name |
| 4 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 5 | PIR_SCHD_NUM | Character(14) | VARCHAR2(14) NOT NULL | PIR Schedule Number |